Creating an Outlook Calendar event in a specific user's calendar

(0) Share

Report

Posted on by MBates237

103

Good afternoon,

I've created a flow which triggers when a leave request in Dataverse (from D365HR) has its status changed to approved. This works as I would expect it to and creates the calendar event

The issue I'm currently facing is, as I am the creator of the flow and the connections to Dataverse and more importantly Outlook are using my credentials, all the calendar events are created in my calendar, regardless of who the leave is for.

My initial thought is using the worker information pulled through previously (From a "Get" step) to put a value in the "Calendar" field in the flow step below

In summary, the flow should be Worker X submits leave -> Leave request is approved -> Event created in Worker X's calendar

Thanks

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MBates87 ,

I am afraid currently this is not possible under Microsoft Flow.
Create Event under Microsoft Flow would require the Flow editor to sign-in office 365 outlook, and currently the authentication can't be configured as available Input under Microsoft Flow.
As the Authentication requires the user to enter their own credentials, currently there is no way for Microsoft Flow to accept the user information and then finish the authentication.
Using team flow only allows the added user to configure the Flow, there is no way to have the Flow Action change its Connection authentication information, currently.
Please consider submit this as an idea, to make Microsoft Flow allow Authentication as an dynamic Input.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best Regards,
Levi

Was this reply helpful? Yes No
MBates237 103 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the confirmation Levi, unfortunately I get an access denied error on the link you've provided.

Was this reply helpful? Yes No
LimaNovember 4 on at

Like (1)

Report
Copy link

Link copied!

Hello, is there any follow-up on this matter? I am looking for some solution within PA too.

Was this reply helpful? Yes No
Suggested answer

ChristyHippo 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I had the same problem, a potential workaround is to create a group calendar say called "Leave calendar".

1. Create the group calendar-https://www.youtube.com/watch?v=QMi5Fc3SkwY

2. Get the leave calendar ID using power automate. https://www.youtube.com/watch?v=OIm6-ooGaPs.

3. Use the specific calendar ID in your workflow. In the create event step of your flow when selecting calendar select "insert custom" and add the specific calendar ID from step 3. Go to advanced settings and put the user in the required attendees then when they accept the invite. It will go to their calendar Automatically as well as the Group leave Calendar.

Only trouble is the user can reject the invite, but it will always show up on the Group Leave calendar.
Another issue is if the item is deleted or changed in Sharepoint list the person will manually need to update the calendar or create an additional flow. These things can get pretty complex quickly. I like to try and keep it as simple as possible and then make small updates at a time.

Hope this helps, If you have found a better solution to this please let me know.

Was this reply helpful? Yes No