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
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?
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.
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.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand