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) )
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
252 | |
122 | |
84 | |
84 | |
67 |