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:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

BradTennent 36 on at

Like (0)

Report

Re: Dynamic dropdown items list

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
BradTennent 36 on at

Like (0)

Report

Re: Dynamic dropdown items list

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.
v-bofeng-msft on at

Like (1)

Report
Re: Dynamic dropdown items list

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