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?

[Eugene-CHN]

Hi, did you solve your problem? I have a similar one

[Anonymous]

@Eugene-CHN  they recently added the ability.

Check this out...

https://powerusers.microsoft.com/t5/General-Discussion/NEW-FEATURE-Depends-On/td-p/241415

[Mira_Ghaly]

Hi @Shanescows ,

I am doing the same scenario on a sharepoint list and filtration is working fine and data submitted fine and when form is reloaded in edit mode it shows the correct value , however if i want to change the selected value in edit mode the list shows nothing except the selected item , appreciate your help

[Andy77Kl]

Hi @Shanescows 

I was able to do like You suggest via dropdown, but how do this with comboboxes? I'm in the middle because creating new works fine with comboboxes, but I don't have any idea how to make it run when I want to edit data (comboboxes are empty).

Problem is that I must to delete On Update "parrent.Defaut" - there's an error and I don't know what to type to select combobox from edited data.

Can someone help me?

[Mira_Ghaly]

Hi @Andy77Kl ,

Can you please post the items attribute value you are passing to your Combobox?

[Andy77Kl]

They're strings - in SharePoint list they're stored as strings.
I try to store them as an lookup , but in this case I have problem to save in SharePoint second cascaded combobox value.

[Mira_Ghaly]

Hi @Andy77Kl ,

can you add screenshots so that i can assist you further?

[Andy77Kl]

Hi @Mira_Ghaly ,

thank you for trying help me.

I have in sharepoint 3 lists:

1. Sub list A - just name and some other details;

2. Sub list B - lookup to 'A' and title for this entry - this works fine;

3. Main List - this list contains lookup to list A, lookup to list B, and other fields;

I want to have in main list lookup B cascaded depending from choose lookup A. This works fine, but lookup B don't save in main list - because I take data for Items from List B (to have cascade) and probably I must to modify submitform event to save data from B combobox in thisItem.

Later on I'll try to send screenshots.

EDIT:

half success: it stores to SharePoint list, but not loading when edit.

To store it, I modify 'Update' of 'B' DataCard to: 

First(Filter(Choices('Lista Maszyn'.'Typ maszyny');Id= DataCardValue4.Selected.Identyfikator))

where 'Lista Maszyn'.'Typ maszyny' is my lookup 'B' and 'DataCardValue4' is my second Combobox;

Now is the question what and where modify to load data correctly to 'B' Combobox.