Calculate Text values in TextInputs in Gallery

(0) Share

Report

Posted on by Sidhant_02

986

Hi everyone,

My scenario was as follows:

On a page I had a galley which was taking inputs as text: Inputs- WFH and WFO.

Default view: Before Entering any values, the 2nd drop-down will be replaced with a new drop down which has only two values in Items property: "WFH", "WFO"

Expected Outcome:

So I did try to use the same formula which I used for calculating number value

The above image might not be clear, but it says that the function value has some Invalid arguments. So please let me know what can be done and also to Reset values of labels, as for text input the reset is working but for labels the value remained the same

@Ramole

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Ramole Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi
We need to change your code like below.

With( { m:Switch(tbMon.Text,"WFH",1), t:Switch( tbTues.Text,"WFH",1), w:Switch( tbWed.Text,"WFH",1), th:Switch( tbThurs.Text,"WFH",1), f:Switch( tbFri.Text,"WFH",1) },m+t+w+th+f )

Make sure you this txMon to txFri to your control name and it should calcalute the label when entered WFH and WFO
To Reset the controls

Add this OnVisible of the screen

UpdateContext({locResetCont:true});UpdateContext({locResetCont:false});

Add On text input Reset property inside gallery

locResetCont

Also is best to add at end of the patch code.

UpdateContext({locResetCont:true});UpdateContext({locResetCont:false});

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report
Copy link

Link copied!

Hi Ramole,
Thanks for the solution it worked, text value was getting calculated as expected:

But for the reset part I did use the context variable onVisible property of the screen and then tried using the same variable inside text property of the label for WFH and WFO, but it was not valid

Regards,
Sidhant

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

Like (0)

Report
Copy link

Link copied!
Hi @Sidhant_02
The variable locResetCont needs be input reset property inside the gallery ~~not on the label~~
Also add this at end of your patch formula, so it will reset whenever you run the patch.

UpdateContext({locResetCont:true});UpdateContext({locResetCont:false});

Let me know if need any more assistance will happy to assist you further.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ramole ,
Initially I was looking for Reset property in the gallery itself (here TimeSheetGallery_1) but I did not find any such property in the gallery so that's why I tried to use it on the label which did not work out
Also you have mentioned to use the UpdateContext after the Patch function but in my case I have not used the Patch function, instead I have used the following on Save:

Regards,
Sidhant.

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

Like (0)

Report
Copy link

Link copied!
@Sidhant_02

Hi
Use the variable on the text input reset property inside the gallery locResetCont

locResetCont

Was this reply helpful? Yes No