Notifications
Announcements
Hi guys,
I get combo box value and store collection. I want search text value and selected value.
So I use formula
Collection(Collectionname,{comboxvalue:combox.selected.value || combox.searchtext})
But it throws error why
please help me
@Mike8
@WarrenBelz
@RandyHayes
@Pstork1
@v-xiaochen-msft
@timl
@BCLS776
@Nogueira1306
@v-bofeng-msft
@gabibalaban
Hi @Gelos
Please try this.
ClearCollect( Collectionname, { comboxvalue: Coalesce( combox.Selected.Value, combox.SearchText ) } )
Note: This clears everything and Collect the fresh data
If you need to collect to the existing collection instead of fresh every time then use
Collect( Collectionname, { comboxvalue: Coalesce( combox.Selected.Value, combox.SearchText ) } )
Thanks,Stalin - Learn To Illuminate
Thanks it works fine.
@StalinPonnusamy
Hi @Gelos - I see from your post you want to collect 'search text value and selected value'? If so, use the following in the OnChange of your combo box:
Collect(Collectionname,
{comboxvalue:combox.selected.value, comboxsearchtxt:combox.searchtext})
It depends on your use case whether you want to clear the collection and collect new each time you change the combo box or whether this is a collection you want to grow for each user session without clearing - if the former, use 'ClearCollect', if the latter, use 'Collect' as shown.
Hope this helps - Good luck
Thanks for your replay.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268