Filter in a Gallery

[lstan]

Hi,

I have 2 tables: the first one is "Employees" and the second one is "Hobbies":

 

In PowerApps I have a Gallery (Gallery1) with the Employees that can be selected:
 

I created a second Gallery where I want to see all the hobbies for the selected Employee:

On Items, I put the following formula, but it has an incompatibility error:

 
Filter('[dbo].[Hobbies]',EmployeeID=Gallery1.Selected.EmployeeID)
 

How can I change the Filter Formula in order to avoid this error?
 
Thank you!
 

[timl · Accepted solution]

Hi @lstan 

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) 
)

[lstan]

Hi @timl,

It worked using Value() function.

Thank you