Unanswered

Use a toggle Switch to set an input field to now()

(1) Share

Report

Posted on by xbommer07

I have found a couple different posts here that are close and I have tried them.

I have a toggle switch that when turned on I want it to set the value in a text input field to the current date and time. I can get this to work using

Patch('RoadSide Event Manager', First(Filter('RoadSide Event Manager', 'Work Order Number'= WOVar)),{On_Scene_Time: Now()});

I am experiencing odd behavior. The toggle is then switched on for every field to automatically be yes, and it updates the time to now every time the form is opened.

The form is opened from a gallery and I need it to pull accurate information from the sharepoint list datasource. So if the value is set to no in the sharepoint list I need it to remain at no until the user sets it to yes. When the user sets it to yes then update On_Scene_Time to the date and time it happens. The tricky part from here is to keep the same value that is in sharepoint first. Then if its already a yes on the toggle leave the value in On_Scene_Time what it was.

Steps needed.

Toggle switch by default on all new records is No.

User reports the activity completed by changing toggle to yes

Once it is marked yes update text input field named On_Scene_Time to date and time now()

Disable toggle so it cannot be changed from yes.

Disable On_Scene_Time so it cannot be edited.

The data source is a sharepoint list and the columns used are Yes/No and Single Line of Text.

Thanks for the help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,962 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @xbommer07 ,
Can you please send a screen shot of your gallery - I assume that this toggle is in your gallery and the Patch code is being run on the OnChange of this control? Also does the toggle have a Default value?

Was this reply helpful? Yes No
xbommer07 40 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello again @WarrenBelz

The toggle sits inside an edit form, and the default is parent.default. I am using oncheck with code, Patch('RoadSide Event Manager', First(Filter('RoadSide Event Manager', 'Work Order Number'= WOVar)),{On_Scene_Time: Now()});

Was this reply helpful? Yes No
WarrenBelz 155,962 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @xbommer07 ,
Before we look at anything else, take the code off the OnCheck and put this on the OnChange (I assume 'Work Order Number' is a unique value) - replace with your control name
If( YourToggleName.Value=true, UpdateIf( 'RoadSide Event Manager', 'Work Order Number'= WOVar, {On_Scene_Time: Now()} ) ); Refresh(YourDataSourceName)

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.

Was this reply helpful? Yes No
xbommer07 40 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz

New code is in place. Something is resetting the switch back to no(false). I have no code anywhere else on this control except the onchange.

If( Sw_OnScene.Value=true, UpdateIf( 'RoadSide Event Manager', 'Work Order Number'= WOVar, {On_Scene_Time: Now()} ) ); Refresh('RoadSide Event Manager')

I see the time get updated in On_Scene_Time then the switch sets itself back to false. Do you think I also need to add the toggle in to the update? Since the default is parent.default we refresh without a submit.

Was this reply helpful? Yes No
WarrenBelz 155,962 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @xbommer07 ,
I was fearing that - OnChange is a better spot for it anyway, but firstly have a read of this post which is currently ongoing and appears to be the same issue as you are facing.
Another thing you could try is to take the update off the toggle and put it on a "Submit" button in the gallery and see if that does the job.

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.

Was this reply helpful? Yes No