Supercharge Your Workflow: Automate Excel Data to SharePoint
Вставка
- Опубліковано 14 жов 2024
- This video is a step-by-step tutorial on how to add Excel data into your SharePoint list using Power Automate flow.
Below is the Excel Table Range Formula:
=$A$1:INDEX($1:$1048576,COUNTA($A:$A),COUNTA(1:$1))
Hi! Thank you so much for the video. I get an Item not found on the Create Table step. Anythoughts on how to fix?
Since I have several lists where I need to upload an excel file. Do I need individual flow for reach lists? Thank you
If each list is different then Yes you will need a flow for each one
So does this mean if my original excel file changes then my
List will be updated?
No your original file is not linked to SharePoint
Great video. I sent an email to you, and I look forward to your response.