cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pasquale_p
Helper I
Helper I

from an excel table to a Sharepoint list

hello everybody, 

I need your help from you to build a new flow where from an excel table (built according Power Query) an interval of one day in the night, the flow update the sharepoint list

💡

excel table --> FLOW --> sharepoint list (interval 1 day)

 

thanks to all will help me

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
PrasadAthalye
Super User
Super User

Your flow should look something like below... 

  • Upload your excel to a sharepoint document library.
  • Select the excel and table in List Rows action.
  • Use Create Item to create new item in SharePoint List. 
  • For Update Item, you should have some identifier from excel which can identify a row in SharePoint List.
  • Then you can use GetItems from SharePoint List and provide filter criteria based on the identifer.
  • Then you can use Update Item to Update the existing item. 

 

PrasadAthalye_0-1620489723974.png

 

Update Item

 

PrasadAthalye_1-1620490073067.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

pasquale_p
Helper I
Helper I

Hi @PrasadAthalye 

starting from your flow, I added the 'delete item' because without, the flow, create duplicate

 

pasquale_p_0-1620543240927.png

 

View solution in original post

3 REPLIES 3
PrasadAthalye
Super User
Super User

Your flow should look something like below... 

  • Upload your excel to a sharepoint document library.
  • Select the excel and table in List Rows action.
  • Use Create Item to create new item in SharePoint List. 
  • For Update Item, you should have some identifier from excel which can identify a row in SharePoint List.
  • Then you can use GetItems from SharePoint List and provide filter criteria based on the identifer.
  • Then you can use Update Item to Update the existing item. 

 

PrasadAthalye_0-1620489723974.png

 

Update Item

 

PrasadAthalye_1-1620490073067.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

Hello @PrasadAthalye 

thanks for your suppor, 

 

for help me, could you upload here the flow?

 

thanks for your support again

pasquale_p
Helper I
Helper I

Hi @PrasadAthalye 

starting from your flow, I added the 'delete item' because without, the flow, create duplicate

 

pasquale_p_0-1620543240927.png

 

View solution in original post

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 (98,921)