Filtering SharePoint List by Multiple Selections Gallery

[holtma]

Hi Everyone, apologies if this topic has been covered already but I am struggling with a PowerApp/Automate and could use some help.

The scenario is as follows: I have a PowerApp where users can confirm their attendance at training sessions. One SharePoint List contains the data of the trainings themselves, while the other SharePoint List records the users who have confirmed their attendance at a training. When a user confirms their attendance, this record is patched to include the ID of the training in the first SP List (creating the one-to-many relationship).

In the app there is a feature where trainers can select their training from a Gallery, press a button which triggers a Flow, which then generates an excel report of attendances (attached is a screenshot of the flow, the "Get Items from Attendance List" is filtered by the TrainingsGallery.Selected.ID). This is working as expected with no errors, returning a sharing link to the newly created excel file with the following OnSelect property: 

Set(
varFileLink,
TEST_LTT_AttendanceReport.Run(GLLRY_AttendanceReports.Selected.ID).reportsharinglink
);
Launch(varFileLink)

The issue which I now have is that we want a trainer to be able to select multiple trainings from the gallery, which we can then filter the Attendance List by. I have tried to achieve this by adding checkboxes to the gallery, which creates a collection of items when the checkbox is selected. However I can't figure out how to amend the above formula to accommodate the potentially multiple ID values of the collection which I want to send to Power Automate. Furthermore, I am not sure how to amend the filter Query in the Flow to accommodate filtering by a variable amount of ID values.

Any help would be much appreciated!

 

[EddieE · Accepted solution]

@holtma 

The way I’d approach this would be to send a string of IDs instead of a single value. I can’t jump on my laptop atm but in stepwise pseudo code it’d look something like this

- use checkboxes to create collection of course IDs

- before flow runs, create a string of IDs

With( {

      wIDStr: Concat( collection, ID & “;”)

   },
   Set( arrayOfIDs, Left( wIDStr, Len( wIDStr ) - 1)

   )

)

So, if Course IDs 1, 5, 6 and 7 were selected the variable arrayOfIDs would be the string

1;5;6;7

- send this string instead of the ID

- use Split function in flow to split this string into an array of IDs

- use Apply to Each to run the flow for each of the IDs

I can help provide more targeted advice if you need it but this is how I’d approach this.

[holtma]

Thank you, @EddieE !

The solution was indeed to create a string of IDs from PowerApps through to Power Automate and split them up after.