Dynamic dropdown items list

(0) Share

Report

Posted on by BradTennent

Hi all,

I couldn't find anything existing that answers my issue, apologies if I failed searching,

In the data source 'Document Control Data Tables' I have three columns, 'Business_Area_code' a multi value choice column, 'Business_Framework' a text column, and 'Business_Area' a text field. I want to use a textbox to enter a Business Area, then using that value, populate a dropdown items with all items from the Business_Framework that have a value in the corresponding Business_Area_code column that matches the text field.

I.e. I want to search a multi value field for a value (from the textbox), and return all the rows that have that value as the items list for a dropdown box.

I have tried,

Filter('Document Control Data Tables',Business_Area_code = txtBusiness_Area_code.Text).Business_Framework

but this only return one record

I hope that isn't confusing.

thank you in advance,

Brad

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @BradTennent ,

Could you please tell me what Business_Area_code is? Is it a text column?

If Business_Area_code is a multiple choice column in a SharePoint list or a Dataverse table , your formula should not work.

If Business_Area_code is a text column , please try:

Filter( 'Document Control Data Tables', txtBusiness_Area_code.Text in Business_Area_code ).Business_Framework

Best Regards,
Bof

Was this reply helpful? Yes No
BradTennent 36 on at

Like (0)

Report
Copy link

Link copied!

Hi Bof,
Business_Area_code is a multi value choice column,
I have added an image of the sharepoint columns below, to help with understanding what I mean( hopefully)
the textbox at the top will have a Business area (Based on the Business_Area Column (Text),
Then the Dropdown Items (Dropdown01) would be populated from the Business_Framework column (Text),
with only those items that have the Business_Area listed in the Business_Area_code column (multi value choice) column.

Was this reply helpful? Yes No
Verified answer

BradTennent 36 on at

Like (0)

Report
Copy link

Link copied!

Hi everyone,
I have worked it out myself the code I used was
Filter('Document Control Data Tables', txtBusiness_Area_code.Text in Concat(Business_Area_code,Value) ).Business_Framework

Thank you everyone, especially Bof
Brad

Was this reply helpful? Yes No