cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

SharePoint list updates from excel

Hi all

 

I created a flow to update a sharepoint list when a excel stored in my business one drive updates.

 

The flow pretty much I want to is to create, modify or delete an item in the sharepoint list whenever you create, modify or delete a register from excel.

 

The flow doesnt work and I get this message:

 

error_flow.JPG

 

The flow I created is:

 

step1.JPG

 

Doing the double click to the flow:

 

 

Delete: 

step2.JPG

 

Update: 

 

step3.JPG

 

step4.JPG

 

Create:

 

step5.JPG

 

step6.JPG

 

A few things I dont know are:

 

What is the value and key column is for. I used the bottler value, but not sure what is for.

 

The ID field for delete and update row not sure what to use there too.

 

Here is a sample of the excel.

 

https://1drv.ms/x/s!ApgeWwGTKtFdhmOiGJWjjginzRFe?e=K6kwLJ

 

Thanks all.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Users online (11,140)