Look up fields in form being set to different value in list

[CarlHRVA]

Hello,

I have been struggling with this issue for some time so I decided to open a new thread. I have a form for a list with 2 look up columns (State and Property)to another list in it. The selection in the first look up(State) determines what values are available in the second look up field(Property).  I've been able to make this part of the form work but whenever a user selects a Property and submits their form, a completely different property is saved to the list. Formulas I currently have are below:

State Items property:

Distinct(Sort('Master Property List', State),State)

State Update property:

{

Id: LookUp ('Master Property List', State = DataCardValue20.Selected.Result, ID),
Value: DataCardValue20.Selected.Result
}

Property Items property:

Filter ('Master Property List', State = DataCardValue20.Selected.Result).'Property (PIM Short Name)'

Property Update property:

{
Id: LookUp('Master Property List',  State = DataCardValue20.Selected.Result, ID),
Value: DataCardValue21.Selected.'Property (PIM Short Name)'
}

Thank you for any help.

[CarlHRVA]

The same thing is happening with another column, Issue Category, where it is submitting a value different than what was selected in the form. This field is not a look up and just a choice field and hasn't been changed since the form was created by PowerApps originally. The Update property for that field is simply:

DataCardValue16.Selected

[v-siky-msft]

Hi  @CarlHRVA ,

Do DataCardValue20 mean 'Status' field and DataCardValue21 mean 'Property' field?

I think there is something wrong with the Property Update property, please try this:

{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:  DataCardValue21.Selected.ID,
Value: DataCardValue21.Selected.'Property (PIM Short Name)'
}

Sik

[CarlHRVA]

@v-siky-msft Thank you for your response! I still get a "Name isn't valid. This identifier isn't recognized." error when trying to use ID in the formula you provided.

[CarlHRVA]

@v-siky-msft Does it matter if the Property look up column has other dependent look up columns? What I mean is, if you select a Property name from the look up column in the form and submit/save, it will automatically fill in the Property Code and Facility ID upon entry. Thanks!

[v-siky-msft · Accepted solution]

Hi @CarlHRVA 

The problem is from Property Items property, since it contains the only column 'Property (PIM Short Name)', you can use LookUp function to get it's ID.

Please modify Property Update property:

{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: LookUp('Master Property List', 'Property (PIM Short Name)' = DataCardValue21.Selected.'Property (PIM Short Name)', ID),
Value: DataCardValue21.Selected.'Property (PIM Short Name)'
}

Hope this helps.

Sik

[CarlHRVA]

@v-siky-msft That did it! Thank you so much. I still have a few other columns not setting the correct value, should I start a new thread for that? These are simple choice columns rather than look ups but no matter what is select they set the same value in the SharePoint list each time. Thank you again.