web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages Not Able to add Condit...

Power Pages

Unanswered

Not Able to add Condition on a calculated field

(0) Share

Report

Report

Posted on by Joao_Santos

2

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.

Any one can help me on this subject?

Thank you in advance.

Categories:

Power Apps portals

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Joao_Santos

You can try setting the business rules in

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

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.

Was this reply helpful? Yes No
Joao_Santos 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Agent Academy Hackathon is happening now!

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans