Multiple formulas in table Value

[Anonymous]

Is it possible to use mulitple formulas in one table Value?

I have a formula that checks to see if the field is blank, and if it is write N/A if not, then write the value:

if(empty(item()?['VenuePresale']),'N/A',item()?['VenuePresale'])

And I have a formula that formats the time in a readable format:

formatdatetime(triggerBody()?['Venue_x0020_Pre_x002d_Sale'], 'dddd dd MMMM yyyy H:mm')

Both of these work absolutely fine on their own, but I need both to work.

When I put both together it just errors 😕

[v-bacao-msft]

Hi @Anonymous,

Could you provide more details about the error, is there an error in the run, or an error occurred while configuring the expression?

I noticed that when you configured the second expression, you would write "x0020" as "x002d", and try to use an explicit function name like formatDateTime.

Please make sure that the Expression you have configured is correct.

I did a test on my side, as below:

if(empty(item()['Title']),'N/A',item()['Title'])

formatDateTime(triggerBody()?['Created'],'dddd dd MMMM yyyy H:mm')

Please take a try again.

Best Regards,

[Anonymous]

hi @v-bacao-msft

This is the error I am receiving:

The expression is correct, the "d" should be there as this is how the column name is displayed.

I have also tried both expressions on their own and the whole flow runs fine.

😕

[Anonymous · Accepted solution]

@v-bacao-msft

I have managed to make it work with the below expressions:

if(empty(item()?['Venue_x0020_Pre_x002d_Sale']),'N/A',item()?['Venue_x0020_Pre_x002d_Sale'])

formatdatetime(item()?['Venue_x0020_Pre_x002d_Sale'],'dddd dd MMMM yyyy H:mm')

Looks like it needed to say item, instead of triggerBody

However.... my output is now showing:

How do I get it to show without the "hightlighted"?

Many Thanks

[Anonymous]

@v-bacao-msft Also fixed this now by combining the expressions:

if(empty(item()?['Venue_x0020_Pre_x002d_Sale']),'N/A', formatdatetime(item()?['Venue_x0020_Pre_x002d_Sale'],'dddd dd MMMM yyyy H:mm'))