Inserting data into a lookup Field via patch

(0) Share

Report

Posted on by TomasSpit

Hello to all.

I'm building an app, which is linked to sharepoint.

The application is linked to a sharepoint list with the name: PGMM_Mentee.

In this sharepoint there is a lookup field, Hard_Skills_Souhaité, that connects to another table, PGMM_Hard_Skills.

I am trying to use a patch, to insert values that i select, but i keep getting errors.

The patch i created so far is with values hard coded, which later on i'll change to values that i get from a collection.

So far this is the patch i made by checking out the forum and other tutorials.

Patch(
PGMM_Mentee;
LookUp(PGMM_Mentee; ID=7);
{
Hard_Skills_Souhaité: {
Id: 2;
Value: "PHP";
}
}
)

The error that i get is that it is expecting a table at the place of Hard_Skills_Souhaité, which is the lookup field in the PGMM_Mentee table.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @TomasSpit ,

You can use LookUp function to get the specific item from Items of the Combo box, based on a selected value:

Patch( PGMM_Mentee; LookUp(PGMM_Mentee; ID=7); { Hard_Skills_Souhaité: LookUp(Choices(PGMM_Mentee.Hard_Skills_Souhaité); Value = collection.Selected.Hard_Skill) } )

Best regards,

Was this reply helpful? Yes No