I am trying to setup a flow that takes updated or new excel rows and turns them into outlook calendar invites/events that are sent to the relevant team member and then mark the excel row as invite sent. At the moment nothing is happening but i am not getting any errors. Any ideas?
Could you please show how you did set up your excel document?
Thanks 🙂
Thanks so much!
Hi @Toadlink,
Couple of queries and suggestions. Does your flow really need to run every minute? It may be better to use the "When a file is modified" trigger. You could put the excel file in its own folder in onedrive and point the trigger at just that folder so it only runs when that excel file is modified (the trigger looks at all files modified in the folder you specify).
Secondly the apply to each on categories is unecessary, not quite sure why you have it there? If there are no categories then the part of your flow updating the row to "Yes" won't run at all. Also I would reccomend not using the "Get a row" trigger using a key value of No as this will cause you to get a lot of failed notifications if it runs every minute, as if there is no row with the value of "No" in the "Invite sent" column the flow will fail.
Instead I would reccommend using the "List rows present in a table" task with an filter query as below:
Here under filter query I have
Invitesent eq 'No'
I did remove the space in the column for Invite Sent as for some reason I couldn't compensate for it in the excel filter query, I normally can in sharepoint ones...
Then I use an apply to each on the result of this filtered list. This way if there are no entries with "No" in InviteSent then the flow will just end as this list will be empty:
I added a key column to the original spreadsheet which just automatically adds +1 to the value above so that there is always a unique identifer.
Have tested and this runs as you describe. Let me know if this helps or if you have any issues.
Full flow in spoiler:
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1