Answered

SP Concurrent Calculated Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an SP List that has a column called 'Title'. In the Title column are let's say 12 different titles.

Five of the titles are tasks that require recertification, after various periods (i.e. once per year, biennial, every 3 yrs. etc.)

The other seven titles do not require updating once they are entered.

I would like to create an SP calculated column with a concurrent formula (if there is such a thing), that will be able to determine the type of cert or qual in the Title column, apply the appropriate calculation and provide a response in the calculated column of 'Compliant' or 'Noncompliant', and 'Certified' or 'Not Certified', based on the date of certification, the current date, and whether the time in between the two has surpassed a certain threshold.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

What was not clear to me here is are you looking for any help or you are updating your thought here?

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is a new request.
Verified answer

JisungHan Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I also can't understand the exact business requirement.

Is it required some synchronous data update based on the title update? If yes, you can add a Power automate that will be triggered by "When creating/updating a sharepoint item" to update something. In that scenario, if the Power automate update some value in a SharePoint item, it would be fallen in infinite loop. To prevent this, the following workaround would be required:

To avoid infinite loop

==============

1. Add a yes/no type column "Status is changed" in the sharepoint list.

2.Every time a user modify the list, if he have modify the "Status" column,he must modify the "Status is changed" column to "Yes",

if he haven't modify the "Status" column,he must keep the "Status is changed" column to "No".

3.You could add an condition under the trigger to check if the "Status is changed" column is equal to true or false.if the "Status is changed"column is equal to true,send the email,if the the "Status is changed" column is equal to false,do nothing.

Or you need calculate the expiring date or validation check for the entry, you can use the occurrence Power automate as below:

If these scenarios above are not your scenario, please make the request as step by step with example field definition to understand your requirement.