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

Multiple formulas in table Value

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.
Capture.PNG
 
When I put both together it just errors 😕
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Multiple formulas in table Value

@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:Capture.PNG
 
 
 
 
 
 
 
 
How do I get it to show without the "hightlighted"?
 
Many Thanks

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Multiple formulas in table Value

Hi @jpacettf,

 

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')

14.PNG15.PNG

Please take a try again.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: Multiple formulas in table Value

hi @v-bacao-msft

 

This is the error I am receiving:

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

😕

Highlighted
Resolver I
Resolver I

Re: Multiple formulas in table Value

@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:Capture.PNG
 
 
 
 
 
 
 
 
How do I get it to show without the "hightlighted"?
 
Many Thanks

View solution in original post

Highlighted
Resolver I
Resolver I

Re: Multiple formulas in table Value

@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'))

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (6,508)