cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

2 REPLIES 2
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.

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!

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 219 members 4,710 guests
Recent signins:
Please welcome our newest community members: