cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpacettf
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
jpacettf
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
jpacettf
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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (26,829)