Skip to main content

Notifications

Community site session details

Community site session details

Session Id : rCVslfSP+GTQzb+HBlLmUW
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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 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…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 385 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 328

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete