cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Helper V
Helper V

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

Highlighted
Frequent Visitor

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

Highlighted
Helper V
Helper V

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.

Highlighted
Frequent Visitor

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

Highlighted
Helper V
Helper V

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.

Highlighted
Community Support
Community Support

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.

Highlighted
Frequent Visitor

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
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (7,779)