Answered

Sharepoint Custom Form Dependent drop down blank

(0) Share

Report

Posted on by Marke525

I have a series of dependent drop downdown and comboboxes. Everything appears to be working, except the final combobox appears to show the list, but it appears blank, i.e. white text on a white background. Here is Items field:

Filter(Locations, Region_Choice = CustRegionValue.Selected.Result)

I have a sharepoint list that is being used to show which locations are assigned to which region.

The result below should be that if I choose APAC for the Region, it shows Asian countries and If I choose EMEA, it shows European countries. As you can see from the screenshots, the list changes in length depending on the region, but everything is "blank".

I've checked the colors, the background is white, the text is black. There are no errors. If I change the items in the lookup list, the length of the Customer location field changes.

By contrast, This code: Distinct(Filter(Locations, Title = CustCoValue.Selected.Value), Region_Choice) works to give me a different set of region choices based on the "title" choice. I've tried adding "Distinct" to this code: Filter(Locations, Region_Choice = CustRegionValue.Selected.Result), but the "blank" results are the same.

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,380 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Marke525 ,

Assuming Region_Choice is a Choice field, this should work

Filter( Locations, Region_Choice.Value = CustRegionValue.Selected.Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Marke525 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Warren,

Thanks for the quick reply and the suggestion. I tried that change and it gives me an "invalid use of "." " error.

Region_Choice is a column in the lookup list (called "Locations") to assign the location to the region:

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,380 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Marke525 ,

So is Region_Choice a Choice Field or a Lookup Field? I am assuming Lookup if that code did not work. If so, try this

Filter( AddColumns( Locations, "Region", Region_Choice.Value ), Region = CustRegionValue.Selected.Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,380 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Marke525 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Marke525 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for checking in, unfortunately none of the proposed solutions have resolved the problem. At the moment I'm just not going to filter the list. I'm still completely puzzled as to why I have one lookup that works perfectly fine, but if I try to create a different lookup with the exact same method, it doesn't work. That just doesn't make sense to me.

Was this reply helpful? Yes No
Evelyn-Jiang 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I have met the same problem, Does anyone have a solution yet?

Was this reply helpful? Yes No
WarrenBelz 156,380 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Evelyn-Jiang ,

Stop using Lookup columns is probably the best solution (I have not used them for many years) - AddColumns is subject to Delegation limits, so the solution will not work on larger lists.

Was this reply helpful? Yes No