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

Re: Filter ComboBox using another field?

Sorry wrong screen shot!

 

Below is the correct one. For some reason, its not recognizing "Portfolio_Status" in the data source...(RD_Portfolio_Compound_List).

Highlighted
egallis
Level 10

Re: Filter ComboBox using another field?


@simms7400 wrote:

@egallis  Hi -

 

Thank you, but that doesn't validate.  Also, Alias isn't a choice column in the data sources.

 

 


What is the datatype of your Alias column then?

simms7400
Level 8

Re: Filter ComboBox using another field?

@egallis  Text.

egallis
Level 10

Re: Filter ComboBox using another field?

Hi @simms7400, can't see your last capture...

simms7400
Level 8

Re: Filter ComboBox using another field?

egallis
Level 10

Re: Filter ComboBox using another field?

Thanks... Ok... So what is the data type of your Alias column ?

simms7400
Level 8

Re: Filter ComboBox using another field?

@egallis  Text, I mentioned it above.

 

Thanks.

egallis
Level 10

Re: Filter ComboBox using another field?

Oups, sorry... Didn't see it (post was too small Smiley Very Happy)...

Ok, so let's summarize the situation here:

  • you have a RadioButton control with 3 values: Asset, Investment, Target
  • you have a ComboBox control in which you want the items to be populated from an Alias text-typed column located in a list datasource that varies according to the selected value on the RadioButton control
  • among the items of the ComboBox you do not want to keep those for which the Portfolio_Status text-typed column in the corresponding list datasource equals "Terminated"

Is that correct?

This is assuming that all list datasources have the 2 columns Alias and Portfolio_Status... Correct ?

simms7400
Level 8

Re: Filter ComboBox using another field?

@egallis 

 

Bingo!! All of your assumptions are 100% correct!!!  Thank you!

egallis
Level 10

Re: Filter ComboBox using another field?

Sorry... I was busy on another matter...

Ok, now that we have the exact goal we just need to find the solution Smiley Very Happy...

Let me do a test on my side and come back to you...

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: 344 members 6,711 guests
Recent signins:
Please welcome our newest community members: