Unanswered

Combobox search string not working after save

(0) Share

Report

Posted on by Englishweb

371

Hello, I still have the unresolved problem of a combobox search not working as soon as the previous search results have been saved to the datasource.

A fresh launch of the app clears the problem, until the data is saved, at which point the search does not work again.

Does anyone have an idea as to why this may be happening?

Any help greatly appreciated!

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (0)

Sort by

SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
If you have linked the datasource directly to the combobox, you might have to refresh your datasource first:
Refresh(DataSource);

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Englishweb ,

Could you please share a screenshot about your app's configuration?

Could you please show more details about the formula you typed within the Items property of the ComboBox?

Further, have you taken a try to reset your ComboBox after your saving search result back to your data source?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please consider take a try with the following workaround:

Add the following formula within the the OnSelect property of your "Submit" button:

// SubmitForm(..) formula or Patch(...) formula to patch data to your data source ... ...; Refresh('YourSPList'); // Add following formulas Set(IsReset, false); Set(IsReset, true)

Set the Reset property of the ComboBox to following:

IsReset

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Englishweb 371 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-xida-msft
Thank you so much for your patience!
I tried your suggestions but I still have the same problem of the search list selection not working after patch.
Here are 2 screen shots of the app and the ComboBox properties.
I hope this helps solve the problem

Was this reply helpful? Yes No
Delid4ve 795 on at

Like
a
(0)

Report
Copy link

Link copied!

Is the items property a variable?

If so when you save the result follow on from this formula by setting the variable again.

From what i can tell it similar to my situation (hopefully i understood it right):

Gallery items set to a variable

Dropdown changes a variable within the variable

gallery doesn't refresh

add Set(Variable,formula) to the end of the on change event for the drop down and it works perfectly.

Seems to be a bug when you have a variable within a variable that is doesn't refresh it.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Englishweb ,

Do you mean that you could not type search key within the ComboBox after you patch data back to your SP list?

Could your please share more details about the value within the Items property of the ComboBox? Is it a variable?

If you set the Items property of the ComboBox to a variable or Collection, please consider re-set the variable or collection after executing your Patch formula.

Please add the following formula after your Patch formula within the OnSelect property fo the "Submit" button:

Patch(...); Set(Variable, ...); // Re-set variable based on your data source // ClearCollect(Collection, ...) Re-collect collection based on your data source

I could not reproduce your issue on my side. Please consider re-create a new app based on your SP list data source, then check if the issue is fixed.

Best regards,

Was this reply helpful? Yes No
Englishweb 371 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-xida-msft @Delid4ve
The items property of the ComboBox is an excel table: DRAFTALLSTUDENTSTABLE, so not a variable
The results of the combobox are sent to the text box:
If(ShowSavedValue, ThisItem.Student2, Concat(S2ComboConcat.SelectedItems, PRENOM & " " & NOM, ","))

The text box is is patched to an Excel datasource:
Patch(DRAFTSUMMARYDATATABLE,ThisItem,{Student2:S2StudentNameConcat.Text});UpdateContext({LetsEdit: false })
;Set(ShowSavedValue, true)

The text box is in collection: ClearCollect(CollectTutorInfoALLS2,{Student2:S2StudentNameConcat.Text})
The Combobox is in collection: ClearCollect(CollectComboS2,{NOM:S2ComboConcat.SelectedItems.NOM});

Does this help identify the problem?

Was this reply helpful? Yes No
Delid4ve 795 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry still trying to understand what you are saying isn't working.

If i get this right:

select combo box values from DRAFTALLSTUDENTSTABLE

send values to text box

patch values to DRAFTSUMMARYDATATABLE **what starts this process**

then whats not working...

also where are the 2 collections you mention, ie when do these get collected and where are they being used?

Was this reply helpful? Yes No
Englishweb 371 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Delid4ve
Thanks so much for your quick reply.
The clearcollect and the patch are all in the OnSelect property of a button
Everything saves to the Excel datasource and the search works fine in the combobox. 😊

However, after saving data the combobox search function doesn't work for further searches (nothing happens when I type the first few letters of a name). Restarting the app cures the problem until the next save.
What have I done wrong??

Was this reply helpful? Yes No
Delid4ve 795 on at

Like
a
(0)

Report
Copy link

Link copied!

Your still confusing me.. 😀

Everything saves to the Excel datasource and the search works fine in the combobox.

contradicts this:

However, after saving data

so it works when you save but then not when you save. Sorry trying to visualise this..

Was this reply helpful? Yes No
Englishweb 371 on at

Like
a
(0)

Report
Copy link

Link copied!

@Delid4ve
Is there a way to post a video? Perhaps that will help show what is happening!

Was this reply helpful? Yes No