Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Excel to Outlook calendar invites

Like (0) ShareShare
ReportReport
Posted on 20 Aug 2019 18:11:02 by 5

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?

snip1.JPGsnip2.JPGsnip3.JPG

 

  • Simen1 Profile Picture
    2 on 27 Aug 2021 at 13:21:48
    Re: Excel to Outlook calendar invites

    Could you please show how you did set up your excel document?

    Thanks 🙂

  • Toadlink Profile Picture
    5 on 20 Aug 2019 at 20:09:07
    Re: Excel to Outlook calendar invites

    Thanks so much!

  • Verified answer
    jwhite Profile Picture
    191 on 20 Aug 2019 at 18:59:35
    Re: Excel to Outlook calendar invites

    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:

     

    ExcelInviteFilter.png

    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:

    ExcelInviteApply.png

    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:

    Spoiler (Highlight to read)
    ExcelInviteFullFlow.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard