Dear Community,
I am new to PowerApp so apologies if the solution is self-evident. So I have been struggling with a cascading dropdown dependent on another cascading dropdown for a Sharepoint form for a while and tried several solutions found on this site and YouTube but without success. The formula I have works in test and gives a delegation warning and I adjusted the settings for the record limit, but although my solution works it will not save the value to the Sharepoint list. Perhaps I have misunderstood what "Records" are referring too and is not a row but individual entries (at which point it makes sense if PowerApp drags in all the default columns from the Sharepoint list), or maybe my formula is missing some code that will allow the selected value to be saved to the Sharepoint list.
So I have three separate lists: IssuesList (about 500 rows ; lookup columns to BusinessPartner & Quality), BusinessPartner (<500 rows, no Lookup) and Quality (<50 rows; Lookup column to BusinessPartner: FileType)
IssuesList is the master list and from where the Form is created. It uses a LookUp from both BusinessPartner and Quality in the form. By looking up BusinessPartner value from the list it automatically looks up FileType (with values A and B) from the same list. Each BusinessPartner can only have FileType A or B.
Quality provides a dropdown for QIndicator value. This value is also either of FileType A or B but by default gives the entire list of course. What I would like to do is create a form which when providing BusinessPartner, it would automatically LookUp FileType (from BusinessPartner) and based on A or B provide a filtered dropdown from Quality for the QIndicator value to show only the values that applies.
I have BP data card looking up BusinessPartner - Choices([@IssuesList].'BusinessPartner')
I used to have a hidden dependent dropdown which provided the FileType (LookUp('BusinessPartner', BusinessPartner=BP.Selected.Value).FileType)), but although it gives the right FileType apparently you can't have dependency on a dependent dropdown. It gives an error in the form for reasons unknown to me.
So my current QIndicator code reads
Filter('Quality', FileType = LookUp('BusinessPartner', BusinessPartner=BP.Selected.Value).FileType).QIndicator
The code works but the value won't save to the Sharepoint list. Do I need to add something like [@IssueList].QIndicator somewhere? Easiest way would be to retrieve the FileType directly from the BP data card chosen value since it's already in the table, but how do I refer to a value which isn't the selected value in the dropdown BP? Or is this really a case of delegation issues and my only chance is to restructure the data?
Thank you.
