web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

PowerApps combobox

(0) ShareShare
ReportReport
Posted on by 457

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 

Categories:
I have the same question (0)
  • Verified answer
    StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on at

    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

  • Gelos Profile Picture
    457 on at

    Thanks it works fine.

    @StalinPonnusamy 

  • Gerard Simpson Profile Picture
    2,987 Moderator on at

    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

  • Gelos Profile Picture
    457 on at

    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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard