Answered

Dropdown with Two Sources

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a 3 dropdowns that are lookups to a SharePoint Site.

The requirement is to make sure dropdown #1 contains the lookup source, but the 2nd and 3rd dropdown must contain the option "None" in addition to the fields from the lookup.

Any ideas??

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

HI Lp939,
pleae fd below the same answered question:

https://powerusers.microsoft.com/t5/General-Discussion/Drop-down-default-for-a-lookup/td-p/113301

You only have to attach your "None" value to the incoming values of the Lookup in the "default" field, making sure that the ID selection is available. Also, be aware because the "None" values could be set to the item if the user does not select anoher value from the Lookup by himself.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous I believe what you are stating is:
User selected a value in DropDown1 and all the other DropDown lists should adjust their list according to that selection, plus, they should also include a "None" option as well (which is NOT a part of your datasources)

If that is the case, you can do this based on the OnChange action of your first dropdown control.
Unfortunately, you have to do this through a separate collection.

So, on the OnChange of Dropdown1:
ClearCollect(dropdown2List, {whateverCoumnYouAreUsingInYour1stList:"None"}, Filter(yourDataSource, yourColumnToFilter=Dropdown1.Selected.Value));
ClearCollect(dropdown3List, {whateverCoumnYouAreUsingInYour2ndList:"None"}, Filter(yourDataSource, yourColumnToFilter=Dropdown1.Selected.Value))

Then on the Dropdown2 and Dropdown3, set the Items to dropdown2List and dropdown3List respectively.

This will give you a list with a "None" as the first item. Just need to pay attention the the column name you are using for your list and make sure it matches the one you are specifying in the new collections you create OnChange.

Hope this helps some.
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the data structure of your SP list data source?

Could you please show more details about the Items property of the dropdown #1? How do you loop up to your SP list within your dropdown #1?

I have made a test on my side, please take a try with the following workaround:

Set the OnVisible property of the first screen of your app to following:

ClearCollect(
Dropdown2Collection,
{Customer_x0020_Name: Blank()},
'20190211_case5'.'Customer Name'
); ClearCollect(
Dropdown3Collection,
{Title: Blank()},
'20190211_case5'.Title
)

On your side, you should type the following formula:

ClearCollect( Dropdown2Collection, {Field2: "None"}, 'YourSPList'.Field2 ); ClearCollect( Dropdown3Collection, {Field3: "None"}, 'YourSPList'.Field3 )

Note: The Field2 and Field3 represents the column (of your SP list) you want to display within your Dropdown #2 and Dropdown #3.

Set the Items property of the Dropdown #1 to following:

'20190211_case5'.'Customer Name'

On your side, you should type:

'YourSPList'.Column1

Set the Items property of the Dropdown #2 to following:

Dropdown2Collection

Set the Items property of the Dropdown #3 to following:

Dropdown3Collection

Best regards,