cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VCousins
Level: Powered On

Excel Online (Business) - What is Key Value?

I'm trying to update a row on a schedule using the "Excel Online (Business) - Update a Row" action but I can't figure out what the Key Value is referring to.

Where can I find the Key Value? There is no explaination on what exactly this is. The Microsoft documentation just states that it's a string and to "Enter the Key Value". There is no dynamic content available.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Excel Online (Business) - What is Key Value?

Hi @VCousins,

 

The Key value is the Key Column's value, if you want to update a row on the excel table, you should enter the Key Column and Key value for identify the special row.

 

So you must know the Key Column's value of the row you want to update.

As is similar with link below:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Error-404-Excel-Business/m-p/209444#M4383

 

Best regards,

Community Support Team _ Alice Zhang
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

3 REPLIES 3
Community Support Team
Community Support Team

Re: Excel Online (Business) - What is Key Value?

Hi @VCousins,

 

The Key value is the Key Column's value, if you want to update a row on the excel table, you should enter the Key Column and Key value for identify the special row.

 

So you must know the Key Column's value of the row you want to update.

As is similar with link below:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Error-404-Excel-Business/m-p/209444#M4383

 

Best regards,

Community Support Team _ Alice Zhang
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

Highlighted
ItIsNotRandom
Level: Power Up

Re: Excel Online (Business) - What is Key Value?

After a few experiments this is what I found:

 

- Key Column: It can be whatever column you want in a table that can serve as a reference to indicate what is the row that will be modified. Make sure that it has unique values, because an error will be generated if duplicate values in this column are generated.

- Key Value: It is whatever unique value you want in the Key Column to indicate what is the row that you want to update.

Example: If you have a table with two columns: Column1 and Column2 and Column1 has numbers from 1 to 5 and you want to update the row that contains a value of 2 in Column1, then "Column1" is your Key Column and the value "2" (without the quotes) becomes your Key Value.

 

I hope this helps!

Caitlin_Knox1
Level: Powered On

Re: Excel Online (Business) - What is Key Value?

I understand this much. The problem I'm running into is being able to use a cell value (in that special row) in a condition branch. Like if this cell = 3 then do this. I can't get the dynamic content to populate in the next step- all I see are the column names again. How can I do this. I know it must be possible. Any help appreciated

 
 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,771)