Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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

Best Regards,

Wearsky

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

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I made a sample for you.

Best Regards,

Wearsky

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

Like
a
(0)

Report
Copy link

Link copied!

Hi Wearsky,

Appreciate the sample. Big thanks for that.

Was this reply helpful? Yes No