I have developed a form in PowerApps, based on an extensive, existing SharePoint List. There is a set of three fields, two of which autofill, based on the user's selection in the first field. (The goal was to ensure a 3-way match of the three fields...in other words, Field 1, called "Program" is a drop-down; there are corresponding entries for Field 2, called "LOB" and Field 3, called "State." Each combination of three is unique amongst the possible 18 options within the Field 1 dropdown.) For Field 1, Items reads, "Sort(Distinct('AHVM LOB Fields',Program),Value) and OnChange reads, "Set(ContactVAR,LookUp('AHVM LOB Fields',Program = DD_Program.Selected.Value)) NOTE: My data source for this piece is an Excel table called AVHM LOB Fields. The Default for Field 2 is ContactVar.LOB; the Default for Field 3 is ContactVar.State. When I create a new record, everything makes its way perfectly to the SharePoint list EXCEPT the contents of Fields 2 and 3. I am newer to PowerApps and have tried bits of all sorts of hopeful solutions to no avail. Any guidance would be very much appreciated!
