Hi all,
Hoping someone can help with this one.
We have a scenario where users wish to raise change requests for reports that the business uses. There are approx 200 reports. A change can be requested that affects one or many of these reports. There may be only one change, or several changes that need to be made to one or many of these reports. Each change request is stored on a SharePoint list called 'MI_Change_Requests'.
For each change request, the jobs are broken down into 'Features'. We want to store these features on a separate SharePoint list called, imaginatively, 'Features'.
So as an example, a user may raise a change request that says I want 3 changes made to 4 reports. What we want to do is store the change request in the MI_Change_Request SharePoint list, but for the 3 changes that are needed, we want to store these as features against each report name, on the Features list. So, for each of the report names that are selected in the change request, we want a new entry in the 'Features' SharePoint list created.
We need the report names to be stored as text in SharePoint so that we can use search and filtering in Powerapps, so we have created a list in SharePoint called 'DD_Options' and listed all of the report names and ID's in there, then created a combobox in powerapps that points to a collection of that list for the report names. Essentially what we want to do is for every report name selected from that combobox, when the screen is saved, we want a new line created in the Features list to be populated with whatever data we want to put into it from the initial Change Request.
Does anyone have any ideas on how I can achieve this please? I've heard the FORALL command may help, but I can't work it out.
Thanks in advance.
Jason.
