Filter A Ref List

[Gerhard-2024199]

Good Day I would like to filter a Ref list. REF_ROWS("Inquiries", "Job ID") I have 2 tables one is Job & Inquiries in Job i have a user example Jhon so i want to filter the ref list to only Jhon's Inquiries not all the users

[baba_sawane · Accepted solution]

Hi Gerhard,

If I understand, you want to filter the list of inquiries that matches the current user. If that's so :

For that you'll need to create a User table to then be able to express who use the app. 

For example you can add an User table with : User Name | Email 

Then, add it to your app. You will then be able to create a virtual column in your Job table with the formula : 

select(Inquiries[Job ID], contains([Name],any(select(Users[User Name],[Email] = useremail() )) ))