I am trying to perform a flow to do the following:
I've tried different ways to grab the data, but the solutions I see all include updating the data, which I don't want it to do. I only want new items added. Below is the most recent one I've been trying to create to make it work. Please help! Thank you 😃
To easily get the data out of Excel it needs to be in cells formatted as a table. You can save the files as a csv instead of Excel and then parse the CSV data to create the SharePoint items (but that requires a few custom steps to do that). Or you should be able to use an Office Script to first format the data as a table automatically.
Okay, thanks; that's what I expected. Let's assume it is in a Table format, how do I finish out my flow to identify which columns to match to my list?
I don't think the filters in the Excel table are propagated in your flow. And you can add an Apply to Each step with the output of your list rows in Excel step, and do a Create Item to create each row as a new item in your SharePoint list.
First you need to read through the table. I've called my excel spreadsheet 'dataTable' and I am only looking for a status with the word 'entry' to show you how you can filter your data.
You then have to read through each row using an Apply to Each for the Value
You can then in the apply to each, create a new sharepoint list item. There is a mapping option but this is rarely needed. This shows you can use the spreadsheet, look up the user from Active Directory or use an expression (utcNow etc.) to populate the new list item.
I'm not quite following; in my flow, I'm already using list rows present in table and create item.
Additionally, I'm not using one file that continually gets updated. It's always a brand new file, so the flow needs to be dynamic. I'm not understanding how I can get the flow to identify which rows to use in a new file and then put them in the right place in the SharePoint list.
Sorry if your solution above answers that, I'm new to all of this, so I may be just misunderstanding what you're trying to say above.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!