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.
Solved! Go to Solution.
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
You need to compare it to a particular row in your table. If you are using a Gallery try this in OnSelect:
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?
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.
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.
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
Thanks for your help BrianS!
User | Count |
---|---|
174 | |
116 | |
85 | |
44 | |
41 |
User | Count |
---|---|
238 | |
152 | |
131 | |
77 | |
72 |