Share
Report
174Hello,
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
Can something like this, posted by Nirav (Akira28) work? It didnt in this particular way, maybe it can be slightly modified:
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)
Can I even use default column "status" in dataverse table to work with it?
I tried to put this simply as in the screenshot so I just see the color changed, yet it doesnt work...errors:
-identificator "status" doesnt recognized
-false argument (color). expected boolean.
-some argument of function if not valid
-color value expected
Categories:
All responses (
Answers (
