cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joao_Santos
New Member

Not Able to add Condition on a calculated field

Good Evening support and Everyone, 

 

I am trying for some time to create a calculated field in a table on a Portal. I can add an Action but not any condition. 

 

This table has the aim to gather all certificates of equipment and this calculated field should calculate time left to expire. 

 

then i'll check what is the best way to issue some email alerts when this date is reaching. 

 

As soon as I click on add a CONDITION, it is getting me this set up, and it seems that I can't change it. 

 

Joao_Santos_0-1640206584106.png

Any one can help me on this subject? 

 

Thank you in advance.

 

3 REPLIES 3
ragavanrajan
Super User
Super User

Hi @Joao_Santos 

You can try setting the business rules in 

 

1. Table> your table > Business rules > Add business rule 

 

ragavanrajan_0-1640209936035.png

 

ragavanrajan_1-1640210079141.png

 


Hope it helps. 
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Dear ragavanrajan, Thank you for your prompt reply.

 

This will be used surely for the highlight or to set a field with priority number.

 

But i would like to have a calculation field with the number of days missing.

 

Do you have an idea why i cannot add a condition ?

 Best regards

Hi @Joao_Santos 

 

Assuming your certificate attachment field is text type, then try pressing ctrl + F5 on the calculation window 

 

For me as soon as I enter double quotes and hit ok then it is converted to two double quotes. Screenshot below 

 

ragavanrajan_0-1640214847734.png

 

Ctrl + F5 will solve your problem I think. Remove the calculation completely and try again 

 


Hope it helps. 
------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

MPP IDEAS updated 768x460.png

Ideas

Discover ideas and concepts from users like you for how to use Power Pages and take your work to the next level.

Carousel News & Announcements

What's New in the Community?

Check out the latest News & Events in the community!

Top Solution Authors
Users online (3,752)