Answered

Concurrent Function breaks Combo Box Primary/Secondary Texts

(0) Share

Report

Posted on by ChiefPraetor

Though I find a lot of value in the concurrent function for efficiency, it has a major issue yet that just hit me again.

Whenever I alter anything in the Concurrent function, it resets nearly EVERY Combo Box that has a dependency on the Collections within it.

Example:

Concurrent(
ClearCollect(TCol1,tblstaff),
ClearCollect(TCol2,tblproducts))

*Adding a Filter to the collection of TCol2 here would cause all of my combo boxes for TCol1 to reset their Primary/Secondary/Search Text properties. (Rendering them unusable as they're now blanks and 0's and 1's, etc.)

In a large application this has a massive impact as you have to waste a ton of time going through a resetting these ComboBoxes.

Does anyone have this issue?

Thank you for your time

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ChiefPraetor，

Where do you put your Concurrent formula within your app?

Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side.

I think you have some misunderstanding in execution mechanism of Concurrent function (or other functions supported in PowerApps).

When you firstly execute the Concurrent function within your app, the TCol1 and TCol2 collection populated well. But when you made come changes within the Concurrent function, the result the Concurrent formula returned before would be invalid, in other words, the TCol1 and TCol2 collection would be cleared. You need to execute the Concurrent formula again to populate the TCol1 and TCol2 collection.

When you made some changes within the Concurrent formula, the TCol1 and TCol2 collection would be cleared or reset, so the Combo Box controls related to the Collection data source would also be reset.

No matther what function you used within an app, when you made some changes to these functions, if you want these modified formula to take effect, you must re-execute these functions within your app.

If you want these Combo Box controls not to be reset when you made some changes to the Concurrent formula, I afraid that there is no way to achieve your needs in PowerApps currently.

Best regards,

Kris
ChiefPraetor 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Based on your response, I believe the "Where" is possibly the issue. I use it primarily in the On Start of the application as it preloads all of the main data into collections. Because it's in the On Start, it doesn't refresh as it can't until it reloads the whole app. That could lead to the combo boxes staying reset to defaults instead of remembering the changes that were made to them.

I've had many combo boxes NOT change to defaults, and so I know that there is someway around this. I'm starting to think that these one's are resetting because this is the only place I collect them.

I'm starting to get the feeling that getting my Combo Boxes to not reset is more about saving the format of the Collections, than the data in them. (Think about local variables, everything has to match and every single use of it saves the formatting to ensure its correct for all of them, saving the formatting whether there is data or not.) Maybe if I place this code elsewhere in the app (that doesn't get activated), it will help save the formatting.

I'll test that out. Thank you for your time.
Verified answer

ChiefPraetor 22 on at

Like
a
(0)

Report
Copy link

Link copied!

My testing was fairly limited as my app takes forever to load in the editor, but I ran it with redundant code on an unused screen to try to save the formatting of the collections and it seemed to work.

I tested it without the code and broke it intentionally, then added it and couldn't break it. I reloaded and did it backwards and couldn't break it with the code, then took out the redundant code and broke it again.

With the redundant code,
changing the original code in the On Start concurrent function no longer cleared my Combo Box Text preferences.

I'll consider this a solution until it breaks again (hopefully it won't cause it's a real pain).