Answered

Pactch a Lookup column in sharepoint list

(0) Share

Report

Posted on by pword

188

Hi All, I want to patch a lookup column in my sharepoint list. My Sharepointlist1 have a Employee Name(Lookupcolumn). from the combobox if I selected a employee name. its auto populate in leave request summary but when i submit , the employee name is blank. Please help me:(

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey! You need to Patch a record...

But, my first advise would be, if you have a form, submit it using "SubmitForm" instead of "Patch"

If you need to use patch, I am not sure, but you can try this:

Patch(
DataSource,
LookUp(DataSource, ....),
{
...
EmployeeName: LookUp( ListeWithEmployees)
}

You can also try to use the Office Connector...

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @pword ,
Please share the items and Default values of the Dropdown and also the Patch() function to start with.
You can also check if something like below will help in your requirement or not.

ColumnName: {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Title: Lookup(OrignalDataSourceOfLookup, Title= ComboBox8.Selected.Value).Title, ID: Lookup(OrignalDataSourceOfLookup, Title= ComboBox8.Selected.Value).ID }

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.

Was this reply helpful? Yes No
pword 188 on at

Like
a
(0)

Report
Copy link

Link copied!

@PriyankaGeethik In my Items in Combobox:
If(
Radio2.Selected.LoginType = "Employee",
Ungroup(
Table({Login: Choices([@'SLDCC Leave Request Table'].'Employee Name')}),
"Login"
),
Radio2.Selected.LoginType = "Approver",
Ungroup(
Table({ALogin: Choices([@'Approvers Credentials'].Approver_x0020_Name)}),
"ALogin"
),
Radio2.Selected.LoginType = "HR",
Ungroup(
Table({HLogin: Choices([@'HR Credentials'].'HR Full Name')}),
"HLogin"
)
)

My Default Property is blank.

Was this reply helpful? Yes No
pword 188 on at

Like
a
(0)

Report
Copy link

Link copied!

@PriyankaGeethik Thanks for your help, but your code is not working 😞

Was this reply helpful? Yes No
pword 188 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nogueira1306 Office Connector is not working either. I have 2 list. list1 and list2. In List 1, i have the employee names, in my list 2 i have lookup column Title from list1 which is employee names. I want to patch the lookup column using labels or in my combobox in my loginscreen. Can you help me?

Was this reply helpful? Yes No
Verified answer

pword 188 on at

Like
a
(0)

Report
Copy link

Link copied!

Its working now. i use this code

Patch('MyDataSource', {'Employee Name':ComboBox8.Selected});

Thanks for the help. @PriyankaGeethik @Nogueira1306

Was this reply helpful? Yes No