cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

 

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 screenshotflow screenshot 

 

Thanks in advance for your help.

2 ACCEPTED SOLUTIONS

Accepted Solutions
efialttes
Super User III
Super User III

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

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Anonymous
Not applicable

@efialttesthe flow worked for me when I used the function:

formatDateTime(triggerBody()?['Created'],'yyyy-MM-ddThh:mm:ss.sssssss') as per your suggestion.

 

Thanks!

View solution in original post

2 REPLIES 2
efialttes
Super User III
Super User III

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

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Anonymous
Not applicable

@efialttesthe flow worked for me when I used the function:

formatDateTime(triggerBody()?['Created'],'yyyy-MM-ddThh:mm:ss.sssssss') as per your suggestion.

 

Thanks!

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,146)