cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eugene-CHN
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

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

Anonymous
Not applicable

Re: PowerApps - Cascading Drop Downs (Edit Mode)

Mira_Ghaly
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

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
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

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
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

Hi @Andy77Kl ,

 

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

Andy77Kl
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

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
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

Hi @Andy77Kl ,

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

Andy77Kl
Level: Powered On

Re: PowerApps - Cascading Drop Downs (Edit Mode)

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
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (6,141)