web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup field not savin...

Power Apps

Unanswered

Lookup field not saving to SharePoint List

(0) Share

Report

Report

Posted on by Sri

559

Hi All,

I have a form where there is a field called Asset ID (lookup field) points to contribution tracker list. And the Default selected items of the Asset ID field is Filter(
Contribution Tracker,
Name = DataCardValue9.Selected.Value
).Asset_ID

and the Update property I have given as {
Value: DataCardValue9.Selected.Value,
Id:
LookUp(
ContributionTracker,
Name = DataCardValue9.Selected.Value
).Asset_ID
}

But the value is saving to the SharePoint list.

Any help/suggestion on this.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Uthhra ,

I am not totally clear where DataCardValue9 comes in here as this is another control (so I have used ThisComboBox in the reference for the Update

{ Value: ThisComboBox.Selected.Asset_ID Id: LookUp( ContributionTracker, Name = ThisComboBox.Selected.Asset_ID ).ID }

Also, you need to ask yourself why you are using lookup colmns at all when you are changing the Items of the reference control.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Sri 559 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I have two list where in Contribution list there are two fields Asset name and Asset ID. And the second is the Consumption list where there is a field "ID" which is a lookup for the Asset ID from the Contribution list. And this Datacardvalue9 is the Name which holds the value of Asset name in the Consumption list. As per the above lookup formula I'm using the Name(Asset name) from Contribution list equal to the Datacardvalue9.Text and get the respective Asset ID for this and stores in the "ID" column in the Consumption list.

Was this reply helpful? Yes No

Join the conversation