PowerApps - Cascading Drop Downs (Edit Mode)

[Anonymous]

I have created a SharePoint Custom Form using PowerApps. I am using Cascading Drop Downs which seem to be working correctly. However, when I go to edit an entry in my SP list, the original drop down selections are showing up and NOT the selections that my users made (and what is showing in the SP list). Am I doing something wrong?

[Shanescows · Accepted solution]

What is the value of your DropDown Default? Assuming you are on a form should be Parent.Default

[Anonymous]

Yup, that fixed it! Thanks so much.

[teylyn1]

How are cascading drop-downs done in the first place in a SharePoint custom list form with PowerApps? I couldn't find much on the web, only for apps that use SP as the data source, but I can't see how I can add a data source in a custom list form. 

Can anyone point me?

[Shanescows]

This video walks you through how I do Cascading dropdowns in PowerApps. It is shown using SharePoint the concept is exactly the same with a different data source.

[Anonymous]

Everything online I've found with exception to this post on Collab365 focuses on cascading dropdowns creating a new app. Maybe I dont totally understand it correctly, but I have a business unit that simply wants to set the properties on there SharePoint based on that choice is made in the prior field.  They need the ability to quickly make changes in the SharePoint list info panel without opening a seperate app.

Shane making a video on "using a cascading dropdown filter in a sharepoint custom form" would be popular I would think. Any help or good articles would be helpful. Thanks in advance.

[Shanescows]

HI @Anonymous my video should work fine in a SharePoint form? Are you having issues applying the concept? Maybe this video on customizing SharePoint list forms in PowerApps will help? 

[Anonymous]

@Shanescows you're a life changer. Your response made me test the formulas in the custom form once more and I found the answer through this post. 

Basically what was stumping me was this formula on the child field...

Distinct(Filter(Projects,Title = PrjNumb.Selected.Value),Project_x0020_Name)

Seems easy I know, but that along with the info on writing the data back to the list such as this..

{
‘@odata.type’ : “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,
Id: Value(LookUp(Projects,Title=PrjNumb.Selected.Value,ID)),
Value: PrjNumb.Selected.Value
}

was just what I needed. Again thanks for your help 🙂

P.S. Try to keep Todd out of trouble.

[Anonymous]

One little thing with this...

I built and tested all this functionality in a list, but in production we are using a library which looks like there isn't the functionality to customize forms yet. Is that true?!

[lavint]

Hi,

I tried 

Parent.default in the drop down control "Default" Property but it says Expected Text Value...

My issue is when I click on the Edit or form, the cascading drop down fields keep showing the "Default" values, not the user selected values

Any solution? Thanks!