Answered

How to covert sharepoint start date and end date to start time datetime time and end datetime for outlook auto reply

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I'm trying to create a flow which is triggered when someone adds a new SharePoint list item through power app.

The idea is to trigger an automatic email to the submitter's manager (which is selected in the form) and to turn on an automatic OOO reply for the submitter. I've successfully triggered the email to the manager, but I'm not sure how set the start time datetime and start time time zone (for Indian Standar time). I am collecting only the leave start date and end date in the SharePoint form. Can I convert this date to the start time datetime required for the automatic reply field?flow screenshot

Thanks in advance for your help.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Did you already try to assign Sharepoint item outputs (Start date| End date)?

If the corresponding columns are configured as "Date only" and it does not you can probably add T00.00.00.000000Z at the end of them in order to comply with ISO 8601

Not with my laptop, unable to test

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@efialttesthe flow worked for me when I used the function:
formatDateTime(triggerBody()?['Created'],'yyyy-MM-ddThh:mm:ss.sssssss') as per your suggestion.

Thanks!

Was this reply helpful? Yes No