cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JMGCORNATOR
Level: Powered On

Combining filter(), startswith() and a dropdown

Hi there,

 

I have a screen in which i have two dropdowns (dropdown_master and dropdown_model)

 

In dropdown_master i have a list of master-id's consisting of 4 numbers identifying the product family.

 

In dropdown_model i have a list of item-id's. The first 4 characters fo the item-id equals a master-id followed by x characters. So the first 4 characteres of the item-id specifies the overall product family while item-id's specify the specific product from within the productfamily.

 

What i want is to filter dropdown_model based on the product family choosen in dropdown_master.  Right now i have the following code in dropdown_model:

Filter(
    '[dbo].[CRONUS TRIMIT W1 Ltd_$Item]';
    Len(No_)>4;
    StartsWith(No_;dropdown_master.SelectedText)
)

But i get an error in startswith() saying that the second argument is not a text-value and therefore illegal.

The len() works fine, so i dont suspect it to be the cause.

 

any suggestions?

 

thx.   

1 ACCEPTED SOLUTION

Accepted Solutions
JMGCORNATOR
Level: Powered On

Re: Combining filter(), startswith() and a dropdown

I have found a solution myself.

 

I have changed "dropdown_master.SelectedText" for "dropdown_master.SelectedText.value"

View solution in original post

1 REPLY 1
JMGCORNATOR
Level: Powered On

Re: Combining filter(), startswith() and a dropdown

I have found a solution myself.

 

I have changed "dropdown_master.SelectedText" for "dropdown_master.SelectedText.value"

View solution in original post

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

Top Solution Authors
Top Kudoed Authors
Users online (6,891)