Update function for lookup columns

(0) Share

Report

Posted on by daniellemaree85

104

Hiya,

I have a 2 Sharepoint lookup columns in a form and this needs to update into a Sharepoint list which is called "skills matrix"

the two columns that need to be update are technology & technology topics.

in the form when a user submits a new skill, im trying use the datacard to add new line item with the field selected. like simlar to this. but however its not working.. any suggestions?

{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Value: ddTechnology.Selected.Value,
ID:
LookUp(TechnologyTopics,
Technology = ddTechnology.Selected.Value).ID

}

It says these records cant be compared record, text. any suggestions?

thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @daniellemaree85

It loooks like the .ID on the end of your lookup selects a text value.
But the ID of your SP list needs a record.
Try this:

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Value: ddTechnology.Selected.Value, ID: LookUp(TechnologyTopics, Technology = ddTechnology.Selected.Value) }

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @daniellemaree85,

In case the Form dropdown Items property is still the standard Choices('skills matrix'.technology) and Choices('skills matrix'.'technology topics') you can simply use ddTechnology.Selected to update the technology and technology topics LookUp columns respectively - depending on your exact look up column name this may vary slightly. (The structure is Choices(FormList.LookUpColumn)

In case you changed the Items property to e.g. a Filter of your technology/topics list, you will indeed need to create your own lookup record structure (expects the columns Value and Id). In your code there seems to be an issue trying to compare Technology with the ddTechnology selected value. You may need .Value at the end (Technology.Value).

Additionally, the ID column in your record should be Id (correct naming for the LookUp record):

{ Value: ddTechnology.Selected.Value, Id: LookUp(TechnologyTopics, Technology.Value = ddTechnology.Selected.Value).ID }

I am a bit confused why you would need the ddTechnology selected value and the ID of the Technology topics in the same record. I would expect that the technology field would need the Value and ID of the selected technology and the technology topic would need the value and id the that topic (not merging both in one record).

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @daniellemaree85,

Could you please tell me that:

1). What is the data source you used to populated to form

2). How you set the Items property of these data card value corresponding to your two LookUp columns

3). Is this TechnologyTopics the source list that your LookUp column retrieve values from?

Was this reply helpful? Yes No