cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AGS94
Level 8

Filtering a ComboBox

 

I see there are other similar posts on this topic, but for some reason I can't wrap my head around my specific issue.

 

I am needing to move from a DropDown to a ComboBox in my app (ultimate goal is to show two lines per item in the ComboBox).

 

The following formula works great in my dropdown, but I cannot figure out what changes I need to make for it to work in the ComboBox:

 

Filter(CollPtAPrd,Value(GrpTot)=Max(CollPtAPrd,GrpTot)).Product

I am getting an "unexpected characters" error.

1 ACCEPTED SOLUTION

Accepted Solutions
AGS94
Level 8

Re: Filtering a ComboBox

Brain-skip moment. Could have sworn I had already tried this, but apparently not. Just needed to remove the ".Product" from the end as follows:

 

Filter(CollPtAPrd,Value(GrpTot)=Max(CollPtAPrd,GrpTot))

View solution in original post

1 REPLY 1
AGS94
Level 8

Re: Filtering a ComboBox

Brain-skip moment. Could have sworn I had already tried this, but apparently not. Just needed to remove the ".Product" from the end as follows:

 

Filter(CollPtAPrd,Value(GrpTot)=Max(CollPtAPrd,GrpTot))

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 93 members 5,302 guests
Please welcome our newest community members: