How to add a column filtering data from another collection in power apps?

Question

I have two collections in power apps:

users:

enter image description here

colAppRoles:

enter image description here

And I want to add a column with the displayN of each role from the colAppRoles collection where appRoleId of users is equal to the id of colAppRoles.

Answer 1

The AddColumns function will help.

1. Create a new Collection colCombined
2. Add a role column
3. Use the LookUp function to apply the appropriate colAppRoles appRoleId to the new role column

Illustrated:

Answer 2

Use the AddColumns function to add a new column to your Users collection where you can use LookUp function to match the IDs and get the DisplayN values in the new column.