Hi - thanks, yes, I am trying to get data thats selected from a cascasding table. I have one table working perfectly and a remote SP list, selected value, is then taken from 1 SP list and is written in to the current list (why this has to be so complicated I will never know!)
Hi, I have since deleted the cards that I was working on, however, these are equivalent......the working card has a fomula of
- SortByColumns(Filter(DoorsVdrs, SupplierValue = DataCardValue1.Selected.Value),"AssignedTo",Ascending)
This is basically limiting column 2 lookup value ("AssignedTo"), by the parent value ("SupplierValue". The values here are writing perfectly and can be seen here.....(due to a column name change, LookUpActionParty is the same field as "AssignedTo")
Where I am now losing the will to live, is then replicating this to a 2nd Drop Down menu.....
There is a Drop Down COMBO box that has 2 choices, so either choice 1 or 2, then delimits the 2nd Depot field by a significant factor.
To me both Depot and LookUpActionParty ("AssignedTo") have the same icon when you choose the add field.
I have been adding a card, then deleting the control and adding a new control and selecting allowed values, and then using the "depends on" little wizard type of thing to say "this field, is dependant on these 2 other fields", which seems to be make sense, is logical etc". The "cranky/stupid" bit is then having to add additonal O Data code etc to the update item in the data card to save this value.....this is where its failing for me?
Below, on the working one, the kind "autofill" kind of text appears and you add in objects from the names of the items etc....Yet here, even though its referencing the same design/data model as the working one, the names do NOT appear, so even ID and here DepotText which are the parent names in the lookup do not appear. Oddly enough though, it did work once, then fail, then on refresh, it then "knocked out" and stopped an unrelated combo box from working - I then had to delete and reinsert the combo box and then the drop down again to try and get them going. However, I have concerns about Combos stopping working in another thread.....
Looking at this other thread though, it now appears (?) that default values are perhaps not good enough and that I have to go back and alter the properties on defaults (?) to get them to work properly....
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
None of the blogs/instructions on cascading menus seem to actually really nail this topic as they all seem to differ very slightly so I have had to read about 10, watch some videos, then literally days worth of trial and error/self teaching etc.....Yeah! Struggling......
