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 Platform Community / Forums / Power Apps / Combobox - for selecte...
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

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 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard