I have taken an excel file with below data
My List structure is as shown below
| Column Name | Data Type | Value |
| ProductName | ProductName | |
| Price | Number | |
| Currency | Choice | USD, INR, CAD |
| ManufacturedDate | Date and Time | |
| InStock? | Choice | Yes, No |
Click on Instant Cloud Flow
Select Manually trigger a flow, Name the flow and Click on Create
Add an Action and search for List rows present in a table. Select the site location and document library where your excel is stored. Select file and table. Specify the date format as ISO 8601.
ISO 8601 specifies that the date portion of a Date Time string is always formatted as yyyy-MM-dd
To add data into SharePoint, add a Create Item action. Because we have list of records in excel it will, add the action in Apply to each loop. Select site address, list name and map the columns from your excel to the columns in SharePoint using dynamic content or you can use expressions as mentioned below.
ProductName: items('Apply_to_each')?['ProductName']
Price: items('Apply_to_each')?['Price']
Currency Value: items('Apply_to_each')?['Currency']
ManufacturedDate: formatDateTime(items('Apply_to_each')?['ManufacturedDate'],'g')
InStock? Value : items('Apply_to_each')?['InStock?']
The data is now stored in SharePoint
If you liked the post, please share it with others 🙂
Please feel free to comment if you are stuck in any step
Thank you for reading 🙂