Good evening everyone,
I'm pretty much a Power Automate beginner and have succeeded in solving most of my issues thanks to this precious forum's passed messages, but there is one problem I cannot solve.
In the company I work in, we have a Sharepoint list in which each item is a user. Each user has several "Other MUs covered" that are attached to it, thanks to a multi-choice column that is filled manually.
Each of these MU has a matching RU. We have a correspondence table in an Excel file stored in my personal OneDrive. It is pretty straightforward :
I am trying to build a flow launched for a specific item from the Sharepoint list that would get every RU corresponding to each MU in the "Other MUs covered" and copy it in the "Other RUs covered" of this Sharepoint list.
I have managed to do the basic stuff : "Get item" + "Select" action on the "Other MUs covered" column to get only the MU's names... but I don't know how to design the heart of the flow, which is to get the matching RU for every MU I get in this filtered array and update the "Other RUs covered" with the result. All my attempts have failed.
Anyone has an idea ? 😄
Best wishes
