powerappspowerapps-canvaspowerapps-formulapowerapps-collectionpowerapps-selected-items

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

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.

Solution

  • 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:

    enter image description here