Solved! Go to Solution.
Hi @Anonymous
Can you confirm the data types of the EmployeeID columns in your tables? For example, if Employees.EmployeeID is type int and Hobbies.EmployeeID is type nvarchar, this could result in this error.
To resolve this type of problem, you can call the Value function to convert text values to numbers.
Filter('[dbo].[Hobbies]', Value(EmployeeID)=Value(Gallery1.Selected.EmployeeID) )
Hi @Anonymous
Can you confirm the data types of the EmployeeID columns in your tables? For example, if Employees.EmployeeID is type int and Hobbies.EmployeeID is type nvarchar, this could result in this error.
To resolve this type of problem, you can call the Value function to convert text values to numbers.
Filter('[dbo].[Hobbies]', Value(EmployeeID)=Value(Gallery1.Selected.EmployeeID) )
User | Count |
---|---|
121 | |
88 | |
88 | |
75 | |
66 |
User | Count |
---|---|
215 | |
180 | |
138 | |
96 | |
82 |