cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jsmilde
Level: Powered On

Powerapps Distinct function with cascading dropdowns is not automatically populated since update

Hi,

 

We where making an app which looks like an intuitive ticket system. We used therefor cascading dropdowns which help us to select the right owner of the the problem that was flagged. We did some small updates and what we see is that our distinct cascading dropdowns are not prepopulating(blank option) the dropdown anymore.. THis was since the update, so what is changed? Our whole app is not working anymore Smiley Sad 

 

Or is there a way to select the first choice?

Screenshots1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Janaboy
Level: Powered On

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

Hi _Corey_,

 

Thanks i got conformation from the premier support as well, also after reverting the changes all the functions started to work again, so at the moment i am fine, but thanks Smiley Happy

 

Best regards,

8 REPLIES 8
MMaver
Level: Powered On

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

I have a similar problem, dropdowns are all blank rather than displaying the first option of the returned list.

 

Its not exactly elegant, but I got around it for the moment by entering a lookup into the default field which searches for the first <> "" entry in my list. This isnt really going to be fun if I need to go back through all my apps though, hopefully we have a fix incomming for this...

Meneghino
Level 10

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

I suspect that there has been an upgrade where we can now have a blank value in dropdowns even if not part of the Items list.  This seems to happen when the Default item is not one of the Items.

This is actually a good development; however this has not been announced.  Does anyone have any more insight or information?

 

Copying @Drrickryp@Mr-Dang-MSFT@timl in case they know...

 

Also copying @Janaboy as he has also come across this issue

panand99
Level 8

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

You can sets the defualt value of your second dropdown field by create a collection on  onChange event of first drop down.

For example :

 

Collect(ClearCollect(CollectionSection,{Result:"-Select-"}),
Distinct(Filter(collWorkflow,Title=FirstDropDown.Selected.Result,!IsBlank(Section)),Section)
)

 

You can now use CollectionSection in second drop down Items events and "-Select-" in default.

 

 

Jsmilde
Level: Powered On

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

Yes

 

I think this problem has been affected by the upgrade.

 

If i put my older version back online (before the last friday),  the app is working again with selecting the right email adresses from the distinct function combined with the filter function.

 

When i go to the edit mode of the latest version you see that you still get the empty pre populated dropdown. 

 

So this means the result of the prepolation is not only a 'select' but could also be a mail adress which is selected. Don't know if your solution is working then @panand99

Janaboy
Level: Powered On

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

For me also another thing is not working.

I select the user and it should autopopulate the field, but it is not working too.

Filter(Table3,Approver_name=Approver_name_box.Selected.Value)

And result selected to show Approver_email and the field is empty.

 

 

PowerApps Staff _Corey_
PowerApps Staff

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

@Jsmilde @MMaver @Meneghino This was an intentional change to fix a longstanding issue with Dropdown selections.  In any event, the change has been rolled back until such time is can be reimplemented in a non-breaking manner.  If the issue is not automatically resolved, please open your app in Studio, save, and republish.

 

@Janaboy We will investigate this behaviour.

Highlighted
MMaver
Level: Powered On

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

@_Corey_ If I could suggest that when it is added back in we have it as an option? Default blank but with an pre set option to enable 1st item in list?

 

Best of both worlds! Smiley Happy

Janaboy
Level: Powered On

Re: Powerapps Distinct function with cascading dropdowns is not automatically populated since update

Hi _Corey_,

 

Thanks i got conformation from the premier support as well, also after reverting the changes all the functions started to work again, so at the moment i am fine, but thanks Smiley Happy

 

Best regards,