Skip to main content

Notifications

Community site session details

Community site session details

Session Id : m7Vr4GSOIwvu07sdzcywFI
Power Automate - Building Flows
Unanswered

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

Like (1) ShareShare
ReportReport
Posted on 16 Aug 2024 00:27:34 by 6
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!  
 
    

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 105

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 90 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 62 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete