cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yeungcase
New Member

How to update a row using multiple key value

Hi All,

 

I'm new to Power Automate. I would like to build a flow to update the row record in a test record spreadsheet:

 

Student ID     Course          Status

123                  ABC         In progress

456                  ABC         In progress

456                  DEF         In progress

 

Say if I build a manual trigger and ask for user to input the info above, how could I setup the "update a row" flow by referencing to both student id and course as the key value and key column?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @yeungcase,

 

Unfortunately, the update a row action only support insert just one key value:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#update-a-row

 

If you want to make Update a row action could update a row according to multiple key-values, you could head to IDEA forum to submit your idea, collect votes to make it come true in the future:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @yeungcase,

 

Unfortunately, the update a row action only support insert just one key value:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#update-a-row

 

If you want to make Update a row action could update a row according to multiple key-values, you could head to IDEA forum to submit your idea, collect votes to make it come true in the future:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Munnazzz
New Member

You could just concact the two columns to create a key column

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,743)