Unanswered

Visible Help

(0) Share

Report

Posted on by smartin

Hi guys

I have a picture that I want to show on visible when a submission through my app gets inputted passed 10 pm at night. I know this code (If(CountRows(Filter(CoachingYear,CoachingTime="22:00"))>0, true , false )) will work to display if the exact time of submission is "20:00" on the dot, but I want it to show for any value that's equal to or greater than 20:00.

"CoachingYear" is my collection name

"CoachingTime" is a column name on my SP list

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

K-A-R-L 715 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @smartin ,

About this issue, using a Timer control would be a good choice.
I added a label control and a Timer control in my App.

On Timer Control:
// you can set the timer control Visible property to False if you want.

Set its AutoStart and Repeat property to: True
Duration property to: 1000 //(timer will change every second)
OnTimeEnd property to: UpdateContext({textbox1:Text(Now(),"dd/mm/yy hh:mm:ss")})

On Label:

Set its Text property to: textbox1

On the image you want to be visible on or after 10PM:

Set its Visible Property to: If(TimeValue(Label1.Text)>=TimeValue("10:00:00 PM"), true, false)

Please click the video.

Cheers

Was this reply helpful? Yes No
smartin 66 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying Karl

I wonder if this set up will work with how I have the app running.
My guys use the app to capture the coaching time that they spend with their folks.
Once they coach, they add their time spent with their employees and submit the form.
The form also captures the time that the coaching session happened. The info gets stored on the SP.

On loading the App, I have a collection pull their data into the collection.

Just not sure how to have the picture load if the time that the session happened was after 10 pm.

Haven't used timers before so little unsure.

Was this reply helpful? Yes No
K-A-R-L 715 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @smartin ,

I just want to ask:
Re: time, how many "time" do you have in total? 2? Which of these is the "CoachingTime" column?
1 "time" when the coaching session happened
1 "time" for when the form is submitted
Is the collected data ("CoachingYear" ) in a gallery set as an item?
will the picture only appear if the "CoachingTime" is greater than or equal 10PM?

If it's on a gallery, set the picture Visible property:

If(TimeValue(ThisItem.CoachingTime)>=TimeValue("10:00:00 PM"), true, false)

Can you please post a screenshot of your app.

Please have a look at that app I created. The male icon will only appear if the user created the Order:

Cheers

Was this reply helpful? Yes No