I have a problem i need to solve but being fairly new to this i am struggling to get my head into it. If anyone has a suggested way to achieve this please let me know, i would prefer to achieve this via an expression rather than change the data tables that already exist as they used elsewhere. First some background.
I have x2 dataverse tables
- ADGroups (with a linked table for ADgroup type). This table contains a list of AD groups per row, name="App - app1", type="App" etc
- Templates - This contains, name="Template for all staff" AppGroups="App - App1; App - App2".
I have a gallery showing names from the table "Templates". When a user selects a template this shows another screen called "Edit Templates". This screen is going to show the various elements that make up a template.
For this to work i have created a new gallery on the screen "Edit Templates" with a label and checkbox. The label needs to show a combination of all the possible available ad groups from the table "ADGroups" and all the items in the "AppGroups" field on the Selected Template. For every item that is in the selected template the checkbox will need to be ticked and for every item not in there the checkbox will need to be unticked.
A user will then be able to tick new adgroups and on submitting this will be updated in a new table which is read by another process and actioned and the source tables above updated.
I have created the gallery and used collections to gather the data and merge them into one collection but now need to create a new column for the checkbox which doesnt exist in the source table.
