Power Platform Community Forum Thread Details

Taking data from multi-select choice in Sharepoint and moving to individual columns in excel sheet

Hello, I have a Sharepoint list with two multi-select columns (along with other data categories) that gets data from an existing Power App. However, on the excel sheet, each of the equipments are displayed in their own individual column. I'm trying to make it so that for each option that was chosen in the multi-select column, it will scan through the Excel sheet columns and mark that specific cell with an X.

As an example, if the user chose Potter and Pleater as their necessary equipments, it would go through the excel table, and in the row alongside the other data of the sharepoint item, mark the columns that were denoted as Potter and Pleater with an X.

I've attached what I have so far, I'm unsure of what to do besides identifying which columns to be marked, hence the double nested loops. I wanted to try update a row, but I don't think there's a key value from the data I have that I can use as a unique ID. Let me know if any clarifications are needed!

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate