Answered

Button visibility based on SharePoint date field

(0) Share

Report

Posted on by ammdaddy

Hi. I'd like to have the visibility of a button dependent on a Sharepoint Date and Time column. Basically, I need the button to show only if the date in the column field has occurred.

I tried doing something like this . . .

Now()>=DateValue('SPList'.'DateColumn')

. . . but to no avail. Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You need to compare it to a particular row in your table. If you are using a Gallery try this in OnSelect:
Set(var_Selected,ThisItem);
Then in the Visible property of the button you can use:
Now()>=var_Selected.DateColumn

If you aren't using a gallery, you will just need to specify a particular row

Was this reply helpful? Yes No
ammdaddy 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks BrianS for your reply. The button is actually on a DetailScreen. I'm new to Power Apps. How do I specify a particular row as you suggest?

Was this reply helpful? Yes No
CU24091509-0 417 on at

Like
a
(0)

Report
Copy link

Link copied!

@ammdaddy
if your gallery name is galRows on screen1
and your form is on screen2
On selected item on galRows navigate to sceen2
Set(varNewFormMode,false);Navigate(Screen2)

and on sceen2 datasource for the form is your list and item is going to be as below.
If(!varNewFormMode,galRows .Selected)

________________________
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
ammdaddy 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Kranthi. I'm a bit more confused than when I started. 🙂 I'm not sure how your suggestion will help show/hide a button based on a the date in a DateTime column. The button's link is already set to navigate to another screen and that works fine. I just need to hide the button until after the date in a date column.

Was this reply helpful? Yes No
Verified answer

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Each field on the screen will be in it's own "Card". That card will have a label and the field. Each of those will have unique name.
If you are using what PowerApps gives yo it will be something like DataCardValue3, so your formula will be along the lines of:
Now()>=DataCardValue3.SelectedDate
for whichever data card is displaying your date column

Was this reply helpful? Yes No
ammdaddy 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help BrianS!

Was this reply helpful? Yes No