cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

PowerApps - Cascading Drop Downs (Edit Mode)

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?

17 REPLIES 17

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

Anonymous
Not applicable

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

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Andy77Kl
Frequent Visitor

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
Dual Super User II
Dual Super User II

Hi @Andy77Kl ,

 

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

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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
Dual Super User II
Dual Super User II

Hi @Andy77Kl ,

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

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,088)