Answered

Set variable updating very slow

(0) Share

Report

Posted on by sskey89

I am setting 6 variables for 6 checkboxes:

Set(resultvariable1, If(One.Value=true,"1",""));
Set(resultvariable2, If(Two.Value=true,"2",""));
Set(resultvariable3, If(Three.Value=true,"3",""));
Set(resultvariable4, If(Four.Value=true,"4",""));
Set(resultvariable5, If(Five.Value=true,"5",""));
Set(resultvariable6, If(Six.Value=true,"6",""))

I then have these going to a text field that will be sent out in an email. The issue is the text field takes a long time to update, so when the email is sent the body of the email remains blank as if the value was false. Any way to speed this up so if a user hits submit the values won't remain blank? I also have a dropdown and text input but those update instantly.

I am new to Power apps, so if there is a better way to do this I am all ears!

Body of email:

Text(Dropdown_Room.Selected.Name) &Char(13)&Char(13)&
Text(resultvariable1) & Char(13)&Char(13)&
Text(resultvariable2) & Char(13)&Char(13)&
Text(resultvariable3) & Char(13)&Char(13)&
Text(resultvariable4) & Char(13)&Char(13)&
Text(resultvariable5) & Char(13)&Char(13)&
Text(resultvariable6) & Char(13)&Char(13)&
Text(TextInput2)

Thanks in advance!!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sskey89 ,

Why not do it all directly in the email ?

Dropdown_Room.Selected.Name & Char(13) & Char(13) & If(One.Value, "1") & Char(13) & Char(13) & If(Two.Value, "2") & Char(13) & Char(13) & If(Three.Value, "3") & Char(13) & Char(13) & If(Four.Value, "4") & Char(13) & Char(13) & If(Five.Value, "5") & Char(13) & Char(13) & If(Six.Value, "6") & Char(13) & Char(13) & TextInput2.Text

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Disregard - duplicate

Was this reply helpful? Yes No
sskey89 74 on at

Like
a
(0)

Report
Copy link

Link copied!

I was testing to make sure that the values were updating accurately. Do you think the slow issue is caused by the text box updating separately?

Was this reply helpful? Yes No
sskey89 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Just tested that and the values still didn't update fast enough. The checkbox's are still showing blank in the email. Only the dropdown and textbox updated and were on the email.

Was this reply helpful? Yes No
sskey89 74 on at

Like
a
(0)

Report
Copy link

Link copied!

I am setting the variables here:
Is there a better place to do that?

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@sskey89 ,

I assume you have dropped the Variables and used the code I supplied. Also can you please supply the actual code as Text - or try this

With( { w1: If(One.Value, "1",""), w2: If(Two.Value, "2",""), w3: If(Three.Value, "3",""), w4: If(Four.Value, "4",""), w5: If(Five.Value, "5",""), w6: If(Six.Value, "6","") }, Dropdown_Room.Selected.Name & Char(13) & Char(13) & w1 & Char(13) & Char(13) & w2 & Char(13) & Char(13) & w3 Char(13) & Char(13) & w4 & Char(13) & Char(13) & w5 & Char(13) & Char(13) & w6 & Char(13) & Char(13) & TextInput2.Text )

The whole point is to ensure the values are set before the email is run.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
sskey89 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Your first solution worked, I had a typo in the formula! Thank You!

Was this reply helpful? Yes No
sskey89 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Would you know how to leave out results that are "false"? I am getting blank entries because of the formatting of the message and using: & Char(13) & Char(13).

Was this reply helpful? Yes No