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

Replicating a onedrive update row in onedrive for business

Hi all,

 

I am trying to replicate a successful flow in  Excel business so that it is not linked to my Onedrive, but based on a sharepoint site.

 

However, when I get to the update row step I cannot work out how to deal with 

*Key Column *Key Value
 
Basically the flow gets form responses and separated them into different spreadsheets based on which teacher the students say is theirs. 
Flow 2.PNG

 

7 REPLIES 7

Re: Replicating a onedrive update row in onedrive for business

2019-02-13_9-08-30.jpg

 

If this is helpful please mark as a solution

IainCONeill
Level: Powered On

Re: Replicating a onedrive update row in onedrive for business

Hi spsolutionsgrp,

 

This is quite helpful, But I think my problem is conceptual. 

 

Do I need to issue each row with a unique ID as a previous step?

 

Should the Key Value be the type of data the update row is looking for?

 

Thank you in advance.

 

Best,

Iain

Re: Replicating a onedrive update row in onedrive for business

Does not have to be ID but I do not know your data so it is hard to say.  The update row action looks at your table and the column that you specified and looks for the value (could be ID or name or any value) and once it finds a row with that value it updates that row.

IainCONeill
Level: Powered On

Re: Replicating a onedrive update row in onedrive for business

Right, I see. So I would use this to update a specific row if I knew which row I wanted?

 

I want my flow to update all rows which meet the above condition. Is there a way of using "current" or something?

 

Maybe I am using the wrong function...

 

Best,

Iain

Re: Replicating a onedrive update row in onedrive for business

Try this.

First get a list of all the rows, then add a contion for what you are looking for.  YOu only need the contion if you don't want to update all. In my example I am only updating records where the name is "Bob".  Then our Key Value is dynamic so we are looping through the entire table. 

 

2019-02-13_12-30-41.jpgIf this helped please mark as a solution.

Community Support Team
Community Support Team

Re: Replicating a onedrive update row in onedrive for business

Hi @IainCONeill,

 

You could choose a column in your excel table as the Key column, and then choose the column's dynamic content in the Key Value field.

 

Please make sure the key column in your table would have a unique value in all rows of your table.

And the key column and key value would be used to identify a single row, so don't update the key column's value in flow.

 

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.

IainCONeill
Level: Powered On

Re: Replicating a onedrive update row in onedrive for business

Hi everyone,

 

Thank you for your help and explanations!

 

I started again from scratch and managed to get it working using the solution above.

 

I think the actuall problem might have been I was using a group location for one flow and a sharepoint location for the other, but I'm not sure what I was doing wrong. the first time round.

 

Thankyou again.

 

Best,

Iain

 

 

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: 233 members 5,130 guests
Please welcome our newest community members: