cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

Formating Date and using HTML Table

I have all the information I want from my flow but I'm getting stuck formatting the dates. My flow is as below:

Capture.PNG

 

expression: 

formatDateTime(utcNow(),'yyyy-MM-dd')
expression:
formatDateTime(addDays(utcNow(),+7),'yyyy-MM-dd')
 
 
 
 
 
 expression:Capture.PNG
formatDateTime(triggerBody()?[' Event_x0020_Date_x0028_s_x0029__'],'dddd dd MMMM yyyy H:mm')
expression:
if(empty(item()?['Venue_x0020_Pre_x002d_Sale']),'N/A',item()?['Venue_x0020_Pre_x002d_Sale'])
expression:
if(empty(item()?['Superfansclub_x0020_Onsale']),'N/A',item()?['Superfansclub_x0020_Onsale'])
 
 Capture.PNG
 
 
 
 Capture.PNG

 
 
 
 
 
 
 
Error message:
Capture.PNG
 
 
 
 
 
 
 
 
 
What am I doing incorrect? 😞


1 ACCEPTED SOLUTION

Accepted Solutions
Resolver I
Resolver I

I figured out that all this was, I DID NOT need a compose, I could put the formula straight in the table as a value, so simple yet so frustrating!

View solution in original post

1 REPLY 1
Resolver I
Resolver I

I figured out that all this was, I DID NOT need a compose, I could put the formula straight in the table as a value, so simple yet so frustrating!

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,875)