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

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Combobox - for selected items return different sharepoint column

(0) ShareShare
ReportReport
Posted on by 47

Hello Experts,

 

Scenario:

Filter(TB_QueryCategory,StartsWith(CateType.Value,"Query"))
  • The above filter returns a list of dropdown from a SharePoint list "TB_QueryCategory"
  • Which is used in a Combobox control.
  • Selected items for dropdown would be column "Sub-Categories".
  • The Source of Combobox items is a SharePoint list, which has a "Sub-Category" column and a "Bucket" column.

TB_Query.png

  • "Bucket" - (1) PM Team (2) Tech Team.
  • I need to determine to whom email notifications are to be sent.  
  • The user would be choosing multiple items from the dropdown. So, the items would fall inside either (1) PM Team bucket or (2) Tech Team bucket or might end up choosing items from both buckets.
  • So, once the user selected the options, we need to return the distinct values of "Bucket" column (out of the selected) and compute it in such a way in a Text Box output saying...
    • PM team will be notified
    • Tech team will be notified
    • Both PM team & Tech team will be notified
  • When the dropdown value is submitted to the main source (another SharePoint list), the result of the text box output would be stored in a column too - Later a Power Automate flow would perform the email notification with its conditions.

Solution required:

What is the best ideal way of accomplishing the above-mentioned Text Box output within Powerapp?

Categories:
I have the same question (0)
  • BideyYusuf Profile Picture
    387 on at
    Re: Combobox - for selected items return different sharepoint column

    What is the best ideal way of accomplishing the above-mentioned Text Box output within Powerapp?

    Hello, @Franklin_vaz this is what i would advise.

    Create a Text column in the sharepoint, perhaps.. name it (Whom to Notify).

    Then whenever you are selecting the Bucket, base on the option you have, you can use a switch function to write into the Text input. 

     

    for example:  

    Switch(BucketDatacard.Value,

    "PM Team","Email Notification would be sent to TeamA",

    "Tech Team", "TeamB would be notify via Email") This is going to be Dynamics, and it would be showing in the text input base on the selected bucket value.

     

    find attached the GIF for example.

     

    let me know if this helps.

     

  • Franklin_vaz Profile Picture
    47 on at
    Re: Combobox - for selected items return different sharepoint column

    Hi @BideyYusuf ,

    Thank you for your reply. The scope is, the user to select "Sub-Category" values from the dropdown. Based on the values selected, adjacent bucket values need to be returned. Sorry if my original post was not clear to you.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard