Unanswered

Leave Requests - After Approval the event is then added to Outlook

(0) Share

Report

Posted on by Community Power Pla...

I am creating a simple system for Approvals of Leave.

When a form is submitted on Sharepoint it then goes through the Approval process. If it is then approved, I would like the event to then be added to a Shared Outlook Calendar.

I managed to get it working for an event o be added to a calendar on Sharepoint but I cant seem to get it to work on the Outlook Calendar.

I think it is because of the date format.

When the request is submitted through the form n Sharepoint (Customerized By powerApps), the dates From and To is in dd/mm/yyyy format but the date needs to be in yyyy-mm-ddT00:00:00 Format. How do I create a formula to chnage the date format in the flow without changing the date format in the Sharepoint list? (Hope this makes sense)

So its the From and To columns in the below:

That needs a formula for it to appear in the correct format in the below - Start time and End Time in the create event part.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

You could try to use

formatDateTime(outputs('Get_item')?['body/From'],'yyyy-MM-ddTHH:mm:ss')

and

formatDateTime(outputs('Get_item')?['body/To'],'yyyy-MM-ddTHH:mm:ss')

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I tried the formulas but it came up with the following error:

Correct to include a valid reference to 'Get_item' for the input parameter(s) of action 'Create_event_(V4)'

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

It worked on my side.

Please provide your flow screenshots.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you

So it is When a item is created - Start and Wait for approval - Condition - If Yes, apply to each - send email notification - update item and create event

Was this reply helpful? Yes No
Emeline1 4 on at

Like (0)

Report

Hello,

I have the same problem as describe.
Maybe someone has a solution ?

Was this reply helpful? Yes No
Emeline1 4 on at

Like (0)

Report

Hi

Solution found. Just need to convert date. Here for start date. Do the same with end date. Before create a outlook event.

Was this reply helpful? Yes No