Submitting Custom SharePoint Forms (via PowerApp) with Lookup data types

[Kalki]

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

}

[Kalki]

@WarrenBelz 

For each of the formulas I'm receiving the following error:

[WarrenBelz]

@Kalki ,

That is not an error - I have given you what I believe is the solution based on the information you posted.

[Kalki]

@WarrenBelz Gotcha.  I guess I said "error" because after the data is posted to the record, it is still not viewable when I open it up.   Surely there's another piece of information missing to populate the information.  What else can I give you to troubleshoot?

Thank you for helping me with this.

[WarrenBelz]

@Kalki ,

The elements of DefaultSelectedItems are 

{DisplayFieldName: ThisItem.ListFieldName}

Based on the information you have posted, what I have supplied is correct.

[Kalki]

@WarrenBelz 

Hey Warren!  So sorry for the delay in response (and for anyone following the chain).  I had to finish large projects for work.

What's listed below is what has currently worked for me with one exception.  There have been times when I've attempted to alter an existing record where the changes do not stick.  What's weird is that not all records have this issues only some of them.  I can't find a consistent pattern to them.  Also, I've set up SharePoint List alerts and the "changes" I submit on the form trigger the alert, but the email alert still shows the same data.  This kind of makes sense because it displays what's actually in the List, but also doesn't because no change was actually made.   Would you please review the following and let me know if anything stands out to you? 

Thank you!

SharePointForm1

Name (NameLU)_DataCard1

Update = {
   Value: DataCardValue1.Selected.Value,
   Id:
   LookUp(
      'Address Log (Map)',
      Title = DataCardValue1.Selected.Value
   ).ID
}

DataField = "NameLU"

Default = ThisItem.'Name (NameLU)'

Display Name = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,'Name (NameLU)')

DataCardValue1

No dependencies

Default = 

DefaultSelectedItems = {Value: ThisItem.'Name (NameLU)'}

DisplayFields = ["Value"]

Items = Distinct('Address Log (Map)',Title)

SearchFields = ["Value"]

TIN_DataCard1

DataField = "LookupTIN"

Default = ThisItem.TIN

DisplayName = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,TIN)

Update = {
   Value: DataCardValue2.Selected.TIN,
   Id:
   LookUp(
      'Address Log (Map)',
      TIN = DataCardValue2.Selected.TIN
   ).ID
}

DataCardValue2

Depends on DataCardValue1

DefaultSelectedItems = {TIN: ThisItem.TIN}

DisplayFields = ["TIN"]

Items = Filter('Address Log (Map)', Title = DataCardValue1.Selected.Value)

SearchFields = ["TIN"]

Ad No._DataCard1

DataField = "AdNo_x002e__LU"

Default = ThisItem.'Ad No.'

DisplayName = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,'Ad No.')

Update = {
   Value: DataCardValue3.Selected.Value,
   Id:
   LookUp(
      'Pursuits Advertisements Log',
      Title = DataCardValue3.Selected.Value
   ).ID
}

DataCardValue3

No dependencies

Default = 

DefaultSelectedItems = {Value: ThisItem.'Ad No.'}

DisplayFields = ["Value"]

Items = Distinct('Pursuits Advertisements Log','Ad No.')

SearchFields = ["Value"]

My No._DataCard1

Datafield = "MyNo_x002e__LU"

Default = ThisItem.'My No.'

DisplayName = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,'My No.')

Update = {
   Value: DataCardValue7.Selected.'My No.',
   Id:
   LookUp(
      'Pursuits Advertisements Log',
      'My No.' = DataCardValue7.Selected.'My No.'
   ).ID
}

DataCardValue7

Depends on DataCardValue3

Default = 

DefaultSelectedItems = {MyNo_x002e_: ThisItem.'My No.'}

DisplayFields = ["MyNo_x002e_"]

Items = Filter('Pursuits Advertisements Log', 'Ad No.' = DataCardValue3.Selected.Value)

SearchFields = ["MyNo_x002e_"]

[WarrenBelz]

@Kalki ,

Which one does not work ?

[Kalki]

@WarrenBelz 

I believe it was the Ad No.  However, now that I think more about it, since I had the data already existing in the list before using the new PowerApps SharePoint form, there may have been some human error where someone entered the wrong Ad. No. but the correct My No.  Upon publishing the form, and attempting to correct the mistake, it resulted in the issue posted above.  I'm not really sure though.   

Thanks again,