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

Change values in Sharepoint List From Excel File

Hello,

I want to change the value of one column of each item of a sharepoint list. For this i have one excel file with two columns (id, value). Is it possible to have a flow who can read the excel file (list rows present in a table) and for each row, get item by the id and change the value (update item)

Regards

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

Yes, that is a relatively simple flow to create.  The steps are exactly what you outlined.

 

1) Use a Manual or Recurrence Trigger 

2) List Rows in Excel Table

3) Apply to each loop on each row in the table

4) Inside the Loop update the SharePoint item using the ID from the row as an Index and updating the value in the column you want.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User III
Dual Super User III

Yes, that is a relatively simple flow to create.  The steps are exactly what you outlined.

 

1) Use a Manual or Recurrence Trigger 

2) List Rows in Excel Table

3) Apply to each loop on each row in the table

4) Inside the Loop update the SharePoint item using the ID from the row as an Index and updating the value in the column you want.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

i've done it but by using one variable for the key (ID) and one variable for the value

I'm reading each line of Excel File, store in 2 variables ID and Value and update SP item from these variables

Pstork1
Dual Super User III
Dual Super User III

That will work as well, although there probably isn't a need to store the values in variables first.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (38,562)