Automate Cloud Flow to disable records that are expired

(0) Share

Report

Posted on by Community Power Pla...

I'm new, not sure how to code the following in Cloud flow?

Table:

UserCertification (UserID, CertificationID, Name, ExpirationDate, Status, StatusReason)

Team (UserId, Name, RoleID)

Business Logic:

Select records from UserCertification that expiration date less than today

If expired, set UserCertifcation.Status=Inactive

Removed user from Team via UserID

Scheduled to run daily at 12am.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous,

It's definately possible with a cloud flow. Use a scheduled trigger , then have a List Rows step to select the records that expiration date < today (note: Dataverse uses UTC formats). The filter expiration data logic would look something like this:

Then have a Update Row action to set the status as inactive.

To remove user from a team use the Unrelate action and pick the relationship of type "Team - teammembership_association"

Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

After the "List Rows", how do you pass the row id for "update row" and same for the unrelate action?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Is there a way to add condition to only update the status if the unrelate step is successful? If I make status be the last step.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

You get by looping through the records found from the List Row action

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

Yes, this is by default. The flow will only execute the step if the preceding one succeeded, and you can change that:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for your patience and providing me guidance.

I figured it out. I need to get both User and Team by ID in order to unrelate user from the correct team.

Was this reply helpful? Yes No