Set the expiration of a record

(0) Share

Report

Posted on by JM-14081323-0

Hello, can I use the date of creation a record made through a form to set the expiration after a year, so I can see the date of expiration, I can set the "Status" active/inactive accordingly and even set the icon (circle) changing colour red to green?

How pls?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

ankit_singhal 590 Super User 2025 Season 2 on at

Like (0)

Report

yes you can use Power automate. Set the expiry date when record is created and create another scheduled PA flow which will trigger daily and check all records which have expiry date = today date and inactive them.

Note: Please mark verified, if it is useful for you

Was this reply helpful? Yes No
Nirav Raval (Akira28) 153 Moderator on at

Like (0)

Report

Hi JM-14081323-0,

Use this method to change color -🤞

Select your form add the below code on success -

>> Set(varExpirationDate, DateAdd(ThisItem.CreatedDate, 365, Days));

Set the gallery or data card with label control and set text property to -

>>If(Today() > varExpirationDate, "Inactive", "Active")

Add a Circle Icon on the screen and set the fill property to -

>>If(Today() > varExpirationDate, Red, Green)

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28)

Was this reply helpful? Yes No