Answered

Cascading dropdowns

(0) Share

Report

Posted on by Gautham001

166

I've worked with cascading dropdowns before but today I've encountered this error "this formula uses scope which is not presently supported for evaluation when i use dropdowns". Please check the screenshots attached aswell.

Any help is needed urgently and most appreciated , thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I can imagine a couple of different issues, but without seeing the context its a bit tricky for me to address.
First, make sure Location is actually a Value. It looks like it might be a Text Data type and you are comparing it to a value.
After that, try making sure Cards is a Collection and try using Cards.Location. You can also try using Search rather than Filter

Was this reply helpful? Yes No
Gautham001 166 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried using , Cards.Location , now it gives me a delegation warning.
But I've used a SharePoint list which contains around 10 items , delegation makes no sense.
All the fields used are choice fields in the SharePoint list.

Also I'm using a form here , not a collection. Just to clarify.

Thanks!

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

Like
a
(0)

Report
Copy link

Link copied!

Powerapps can still run with warnings, but I think you get a delegation warning because you are trying to call distinct on the return (filter) and it can't guarantee that it won't have a delegation issue. If you try to collect the result of the filter into a collection, then call distinct, I think it will remove your warning. Hope that helps

Was this reply helpful? Yes No
Gautham001 166 on at

Like
a
(0)

Report
Copy link

Link copied!

I need to update the selected values to the SharePoint list , any ways to do that? I'm using submit form , but the form isn't complete yet.

Also the my original problem isn't solved yet. The plant column doesn't get filtered based upon the choice made in location.

Should the plant column be a text field in the SharePoint list? (This would change the form right , might be a wrong suggestion)

Sorry for too many questions , I'm still a beginner!
The same scenario worked fine when I used a excel file as a data source , but I need this to work on a SharePoint list!

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

Like
a
(0)

Report
Copy link

Link copied!

If you have a dependent dropdown, this is how I handled it in my app:

Your 'Plant Names' Items property is set to a collection, called ' PlantNames' or whatever. In the OnChange property of Location, you ClearCollect into the collection PlantNames your filtered list. After that, you reset the PlantNames field.

Currently, if you change your Location, your Plant Name dropdown options won't update right away, and the user might be allowed to select a Plant Name that is not applicable for your Location. Trying to do your calculations in the Items property is going to cause warnings and issues for you. Its better to do your calculations in properties that are explicitly called, like OnSelect or OnChange.

Was this reply helpful? Yes No
Gautham001 166 on at

Like
a
(0)

Report
Copy link

Link copied!

So , I should make the calculations in the on select of Location?
How do I achieve this? , Using a variable?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gautham001 ,

I think there is something wrong with your code. It should be like this:
Filter(Choices(Cards.'Plant Name'),Value in Filter(AddColumns(Cards,"Column1",'Plant Name'.Value),Location.Value=DataCardValue11.Selected.Value).Column1)
Test Result:
Sik

Was this reply helpful? Yes No
Gautham001 166 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @v-siky-msft , the code worked perfectly , but could you maybe explain it to me so i would'nt have to bother you later again? :D.

Why is "Column 1" used. Also is it possible to get 'Plant Name' Field in a Text Box rather than a dropdown ? If so , how?.

Thank you for the help @v-siky-msft and @Anonymous for assisting.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gautham001 ,

Since the 'Plant Name' is complex field which is not supported for evaluation, so I use AddColumns function to create a new column to save the Value of 'Plant Name' column.
Why do you want a Text box? What does it mean? The Text box is not supported to select options if there are multiple options.
If there is only one option and you want it shown in the Text box by default, please try this:
Set Default property of Text box

First(Filter(Choices(Cards.'Plant Name'),Value in Filter(AddColumns(Cards,"Column1",'Plant Name'.Value),Location.Value=DataCardValue11.Selected.Value).Column1)).Value

Modify Update property of Datacard:

LookUp(Choices('Test 0910'.Cho),Value = TextInput1.Text)

Hope this helps.
Sik

Was this reply helpful? Yes No
Powerplatform01 386 on at

Like
a
(0)

Report
Copy link

Link copied!

No worries, watch this video to resolve your issue
https://youtu.be/Jq_qSZv98OI

Was this reply helpful? Yes No