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 Platform Community / Forums / Power Apps / Comma Value is getting...
Power Apps
Answered

Comma Value is getting inserted even if combo boxes items are not selected

(1) ShareShare
ReportReport
Posted on by 184
Hi,
 
I am trying to capture the combo box selected item value IDs from two combo boxes in the patch function.
 
MS Graph and Power BI combo box values are being populated based on the selected items in API Permission drop down.
 
So first I am selecting the values in the drop down MS Graph and Power BI combo boxes.
 
There after I am unselecting the values in the MS Graph and Power BI combo boxes
 
But if combo box items are unselected but still selected value items IDs are being captured.
 
So in the MS Graph drop down, I have written code snippet as below in the default property
 
Concat(ComboBoxMSGraph.SelectedItems, Auto_ID , ",")
 
In the MS Graph combo box, below is the code snippet that has been written
 
Filter('Permission Lists', 'Resource Name'.Name = "Microsoft Graph")
 
In the Power BI combo box, below is the code snippet that has been written
 
Filter('Permission Lists', 'Resource Name'.Name = "Power BI")
 
Below is the code snippet that has been written, please let me know if I am missing anything here
 
'Permission Lists': If(
            !IsEmpty(ComboBoxMSGraph.SelectedItems),
            Concat(
                ComboBoxMSGraph.SelectedItems,
                Auto_ID,
                ","
            )
        ) & If(
            !IsEmpty(ComboBoxPowerBI.SelectedItems),
            ","
        ) & If(
            !IsEmpty(ComboBoxPowerBI.SelectedItems),
            Concat(
                ComboBoxPowerBI.SelectedItems,
                Auto_ID,
                ","
            )
        )
 
Result
Regards,
Sudheer
Categories:
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    153,117 Most Valuable Professional on at
    The first thing that jumps out to me here is 
    So in the MS Graph drop down, I have written code snippet as below in the default property Concat(ComboBoxMSGraph.SelectedItems, Auto_ID , ",")
     
    Why are you setting the Default  to this value - it is referring to itself for a start and will still refer to this value when reset.
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    Visit my blog Practical Power Apps    LinkedIn   

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

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard