Answered

Making a button invisible a day after it's been created

(0) Share

Report

Posted on by syhrh

997 Super User 2024 Season 1

Hi, I have this customised SharePoint form. I put this Cancel Request button on that form. So, every item in the form has this button but the visibility makes it different. I'm having issues with its visibility. I want it to be invisible a day (24 hours) after it's been created.

I tried this formula but it doesn't work. I want the checking to be for the item so I compare it to the ID.

//Button3.Visible
LookUp('Leave Request',ID=SharePointIntegration.SelectedListItemID).Created > DateAdd(Today(),1)

Can anyone help me?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @syhrh ,

Do you want exactly 24 hours or just not be visible the next day (or any day not the present day) - for the day (the issue you have is that Created is Date/Time whereas Today is just a Date (at 0:00)<

With( { wCreated: LookUp( 'Leave Request', ID = SharePointIntegration.SelectedListItemID ).Created }, Text(wCreated,"dd/mm/yyyy" <> Text(Today(),"dd/mm/yyyy") )

If you want 24 hours

With( { wCreated: LookUp( 'Leave Request', ID = SharePointIntegration.SelectedListItemID ).Created }, DateDiff( wCreated, Now(), Hours ) < 24 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
syhrh 997 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz, I want it to not be visible after 24 hours after it's been created. I pasted your second formula and changed "> 24" to "< 24" to make the button visible if it's less than 24. Thank you so much for your help.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @syhrh ,

Fixed on original post - I must have been focussed more on code than logic at the time.

Was this reply helpful? Yes No