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

(0) Share

Report

Posted on by CarlHRVA

601

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No