Unanswered

SharePoint list to Excel flow: how to get JUST the new items

(0) Share

Report

Posted on by OneWinPlease

155

Is there any way to create a flow where ONLY the new items added to a sharepoint list can write to an Excel spreasheet? My current flow is

When an Item is Created
Get Items
Apply to Each
Add Row to Table

The test list has 10 items. Each time the flow runs, it adds those 10 items plus the new one I add to the spreadsheet. But when I try to remove the flow's Apply to Each, this action automatically gets added back in. Is there a formula or other strategy I can use to restrict the flow to only new items added? (Either instantly or once an hour or day, etc.)

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
SharePoint list to Excel flow: how to get JUST the new items

Can you clarify the need for the Get Items and Apply to Each action? The Apply to Each action is used to loop through an array of items. In your case, you are using it to loop through the SharePoint items.

If you only want to add a new item, you can simply remove the 2nd and 3rd actions from your flow.

When an Item is Created

~~Get Items~~

~~Apply to Each~~

Add Row to Table

Your new flow logic will be. when an item is created—add it to your Excel table.

When an Item is Created

Add Row to Table

To learn more about the Apply to Each action, check out this YT tutorial: 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:
1️⃣ Looping through a Single Item
2️⃣ Creating Unnecessary Nested Loops
3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.
IN THIS VIDEO:
✅ How to avoid the Apply to Each action with a single item array
✅ How to use the item() function to access dynamic content in an array
✅ How to prevent unnecessary nested Apply to Each action loops
✅ How to use the Select action
✅ How to convert an array to a string with the Select action
✅How to use the Filter Query field
✅ How to count the number of items in an array
✅ How to use a condition control
✅ How to use the concurrency control
✅ How to set a top count
✅ How to use Compose actions for troubleshooting

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
OneWinPlease 155 on at

Like (0)

Report

SharePoint list to Excel flow: how to get JUST the new items

Edit:
@creativeopinion, you were correct, I didn't need the Get Items or Apply to Each actions at all. Thank you! (The site is acting up, though, and won't let me select yours as the answer. I can check the box but the page just hangs, partially loaded, and won't settle. Sorry about that.)

********

Thanks for your reply. I am going to try it today and will come back to report. Right now, I got the flow to work if I stick with my original configuration but filtered it with this formula. It will return items created in the last 3 minutes, but it could be changed to another number, or hours, or days. It's not ideal so I hope yours works!

Created ge addMinutes(utcNow(), -3)

(Of course, this requires my Created column to include minutes. Which I think it does automatically.
It also requires a Created (date) columnn.)

Was this reply helpful? Yes No