Unanswered

Auto update calculated feild based on time

(0) Share

Report

Posted on by sairampoosarla

I am building a membership table, where based on number of years they are member the category of membership changes, i.e., if a person is member for less than 5 years then they are bronze category, if they are members for 5-10 years then they are silver category and so on.

How should I create a calculated category field such that it will auto update i.e., if a person has been members for more than 5 years the category field should auto update to Silver.

Thank you

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

365-Assist 2,324 Moderator on at

Like (0)

Report

You could use Power Automate using a Scheduled Flow to do this.

--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
sairampoosarla 7 on at

Like (0)

Report

Hi Darren,

I am new to power apps and power automate, can you expand more on the solution you have provided.

Thank you

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (1)

Report

The Power Automate Flow would look something like this.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No