Answered

Get value for dropdown list from sharepoint list based on value in another dropdown

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

Currently I have 2 dropdown list 'dropdownTOV' and 'dropdownBC'. dropdownTOV get the value based on sharepoint list 'TypesOfVisitor' and dropdownBC get value from 'BuyerInCharges' sharepoint list. I have no issue to get both dropdown value rom both sharepoint list.

But now i need to get the dropdownBC value based on the selected value from dropdownTOV.

example :

if user select CONTRACTOR from dropdownTOV so the value on dropdownBC only display value that status = CONTRACTOR.

hope u guys can help me to slove this problem. Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @Anonymous ,

What's the data type of column named 'Status'?

If it's text column, please try this formula in items attribute of second dropdown control.

Filter(BuyerInCharges,Status = <first dropdown>.selected.Title)

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Wearsky,

Appreciate your response, unfortunately it's doesnt work well. The datatype for Status is text

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

Sorry, it should be .Selected rather than .selected.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Wearsky,

Now the formula has no error but the output is not as expected. Can I know the '.Selected.Title' is refer to which sharepoint list? BuyerInCharges list or TypesOfVisitor list?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

It should refer to the TypesOfVisitor list, I see that there is a column called Title in it.

Could you share the formula of your first dropdown?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Wearsky,

this is my formula from my first dropdown.

I also changed the Title as in the sharepoint list but still the output remain blank as before.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Wearsky,

Now I know what is the problem. I made changed on the value in properties and the dropdown work as expected. Thanks for your formula. It's help me!

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Anonymous ,

I made a sample for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Wearsky,

Appreciate the sample. Big thanks for that.

Was this reply helpful? Yes No