Fill text based on a date choice.

(0) Share

Report

Posted on by BrunoVieira3

Hello

Im trying to create a formula to fill a textbox on a gallery based on a date field, something like

If(Thisitem.Date > todaydate ; "Valid", today.date+30 days, "Waiting, "Invalid")

Basically if the due date is bigger than today is valid, if is less but is within 30 days it still valid but waiting, and after that is invalid...

Is it possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

RogierE 879 Moderator on at

Like (1)

Report
Copy link

Link copied!

If(ThisItem.Date > Today(), "Valid", If (ThisItem.Date > DateAdd(Today(), 30, Days), "Waiting, "Invalid"))

Please like the reply and/or accept it as the solution if the answer is what you were looking for.

Was this reply helpful? Yes No
BrunoVieira3 39 on at

Like (1)

Report
Copy link

Link copied!

Had to remove the "days" for it to work on Brazil powerapps.

Was this reply helpful? Yes No
BrunoVieira3 39 on at

Like (0)

Report
Copy link

Link copied!

Sorry, the Waiting did not work...

Was this reply helpful? Yes No
BrunoVieira3 39 on at

Like (0)

Report
Copy link

Link copied!

On my code it got like this:

If(ThisItem.VENCIMENTO > Today(); "VÁLIDO"; If(ThisItem.VENCIMENTO > DateAdd(Today();30;TimeUnit.Days); "EM VALIDAÇÃO"; "INVÁLIDO"))

"VALIDO" AND "INVALIDO" WORKS, "EM VALIDAÇÃO" SHOWS BLANK

Was this reply helpful? Yes No
Verified answer

jrletner 720 Moderator on at

Like (2)

Report
Copy link

Link copied!
@BrunoVieira3 this should handle the waiting. Also, need the minus "-" sign in front of the 30. That way it goes back 30 days prior.

If( DateValue(ThisItem.Date) > Today(), "Valid", If( DateValue(ThisItem.Date) <= Today() && DateValue(ThisItem.Date) >= DateAdd( Today(), -30, TimeUnit.Days ), "Waiting", "Invalid" ) )

If my post helped you solve your issue, please click 'Accept as solution.' This will assist others in finding the solution more easily and will also close the item. If you found the content useful in other ways, feel free to give it 'Thumbs Up.'

Was this reply helpful? Yes No