Hi @Mdroid ,
Here’s a high-level approach to achieving this:
Use the AddColumns function to expand the RoleTable with a new column that will hold the concatenated string of module names.
Inside AddColumns, use the Filter function to get relevant records from the RoleRelevanceTable based on RoleID.
For each filtered record, use the LookUp function to find the corresponding ModuleName from the TrainingModulesTable using ModuleID.
Use the Concatenate function or similar text functions to create a single string of module names for each role.
Here’s a rough outline of how you could set up this formula in PowerApps:
ClearCollect(
JoinedCollection,
AddColumns(
RoleTable,
"Required Training",
Concat(
Filter(
RoleRelevanceTable,
LookUpRoleID = RoleID
),
LookUp(
TrainingModulesTable,
ModuleID = LookUpModuleID
).ModuleName & " / ",
""
)
)
)
This will look up the tab in the collection where the TabId matches the CurrentTabId.
Kindly mark the solution as accepted if it resolves your issue.
Best Regards
Muhammad Mudassar Mazhar
