cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

PowerApps to Flow Date Format problem

 

I'm using a combination of PowerApps, SharepointOnline and Flow to send out e-mail alerts.

 

So I have the dates in a Sharepoint list and want to use them in Flow to send out my e-mail

 

I'm using the "Compose" action to format the date i.e. "@formatDateTime(,'dd-MM-yyyy')" complete with the double quotes on the outside (I also tried "@formatdatetime( ,'yyyy-MM-ddThh:mm:ss')" ), but this is generating an error message. See screen shot below. Any guidance would be greatly appreciated.

 

DateFormatError.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: PowerApps to Flow Date Format problem

 

After much searching and testing, I finally managed to format a date (in Date only format) retrieved from a Sharepoint List, to 'dd-MM-yyyy'

formatdatetime(items('Apply_to_each')?['IsDueDate'] ,'dd-MM-yyyy')

Thanks to several posts I found here in the Community

This post https://powerusers.microsoft.com/t5/Connecting-To-Data/formatDateTime/td-p/24013 by @v-micsh-msft was particularly useful.

 

View solution in original post

1 REPLY 1
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: PowerApps to Flow Date Format problem

 

After much searching and testing, I finally managed to format a date (in Date only format) retrieved from a Sharepoint List, to 'dd-MM-yyyy'

formatdatetime(items('Apply_to_each')?['IsDueDate'] ,'dd-MM-yyyy')

Thanks to several posts I found here in the Community

This post https://powerusers.microsoft.com/t5/Connecting-To-Data/formatDateTime/td-p/24013 by @v-micsh-msft was particularly useful.

 

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,089)