I've got a fairly simple form for me to fill out on SharePoint. Four form fields total, two are dependencies.
Name, TIN, Ad No., and My No.
These four columns are all lookup types. The first two reference a master list of names (Title column) and TINs (TIN column) on a SharePoint List "Address Log (Map)" - both type Text on source list. The second two fields also reference a separate SharePoint List "Pursuits Advertisements Log" (Ad No. column and My No. column), also text data types.
Unfortunately, the lookup fields won't transfer to my SharePoint List when I hit submit on the published form. Therefore, I tried updating the "Update" property for one of the fields as a test. But I can't figure it out.
Here is how I set up my formulas on PowerApps. They are all combo boxes.
Name (NameLU)_DataCard1
DataCardValue1
No dependencies
- Items = Distinct('Address Log (Map)',Title)
- DisplayFields = [""]
TIN_DataCard1
DataCardValue2
Depends on DataCardValue1
- Items = Filter('Address Log (Map)', Title = DataCardValue1.Selected.Value)
- DisplayFields = ["TIN"]
Ad No._DataCard1
DataCardValue3
No dependencies
- Items Distinct('Pursuits Advertisements Log','Ad No.')
- DisplayFields= ["Value"]
My No.
DataCardValue7
Depends on DataCardValue3
- Items = Filter('Pursuits Advertisements Log', 'Ad No.' = DataCardValue3.Selected.Value)
- DisplayFields = ["My No."]
This all works great within the PowerApp designer interface. However, like I mentioned, the lookup fields won't transfer to my SharePoint List when I hit submit on the published form.
Here is my "Update" property attempt:
For the Name form field's "Update" property, the formula below normally has "ID" where my first red "Value" is located (below). But that doesn't populate anything in Intellisense. For the second red "Value" (also below), I tried replacing it with "Title" from my original source data but that didn't do anything either. Intellisense wanted to put Value for both slots. After trying multiple different variations, I'm stuck. I'd be grateful for some help.
Update =
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: DataCardValue1.Selected.Value,
Value: DataCardValue1.Selected.Value
}
