Search a Sharepoint list for items that match criteria and add an array of all results to an existing item in another sharepoint list.

Like (0) Share

Report

Posted on 25 Aug 2022 13:51:35 by cholyk

I have two sharepoint lists:

List A: Each item is a unit of the hospital. One column is a multi-select person or group column that lists all the physiotherapists that work on the unit.

Unit list.png

List B: Each item is a physiotherapist (Single line of text column). I would like to have a column in List B that will display all the units that the physiotherapist works on based on a search of List A.

staff list.png

I'm hoping I can use power automate to search List A for the physiotherapists name in the multi-select person or group column and then return an array of all the units that physiotherapist is working on each separated by a semicolon or comma. Multiple physios may work on one unit and a individual physio may work on multiple units. Ideally, the flow would trigger automatically any time there is a change to the assigned physio in List A.

I don't have a start of a flow to screenshot here because I don't even know how to get started. Any help would be very much appreciated!