web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Auto update calculated...
Power Apps
Unanswered

Auto update calculated feild based on time

(0) ShareShare
ReportReport
Posted on by 7

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

I have the same question (0)
  • 365-Assist Profile Picture
    2,324 Moderator on at

    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

  • sairampoosarla Profile Picture
    7 on at

    Hi Darren,

     

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

     

    Thank you

  • 365-Assist Profile Picture
    2,324 Moderator on at

    The Power Automate Flow would look something like this.

     

    365Assist_0-1680656050420.png

    ---------------------------------------------------
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard