Unanswered

Need to Update Share point List - Lookup Column using Patch in

(0) Share

Report

Posted on by SushReus

Hi ,

I Have two lists Employees And Cities. There s A Lookup Column City in Employees which looks upto Column City in Cities.

On the Click of Update in Application . The Vlaue in the Tetx Box Near to The update should Update the DropDown Column City which is a lookup Column . Please let me know how the Patch Function should be Written .

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SushReus

Try using the below expression:
Patch(Employees, LookUp(Employees,Title = TextInput4.Text), { City:{Id: LookUp(Cities,Title = TextInput9.Text).ID,Value:LookUp(Cities,Title = TextInput9.Text).Title} })
Here, I have created a similar scenario to patch the updates.
TextInput4 holds the employee Name, TextInput9 is the textbox beside Submit button to hold the new Value.
As per my Employees SP list, I have stored Names in the title, so if you want to match with some other column, please update the column name in lookup query.
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @SushReus

Could you please test with @yashag2255 's suggestion?

Is it solve your issue?

Best Regards.

Yumia

Was this reply helpful? Yes No
SushReus 12 on at

Like
a
(0)

Report
Copy link

Link copied!
The City Column in Share point List . Is it a look up column - Drop Down ?

There is no error in the Function But after I Click on Update . There s nothing Updated in Share point List.
@yashag2255 wrote:
Hi @SushReus

Try using the below expression:
Patch(Employees, LookUp(Employees,Title = TextInput4.Text), { City:{Id: LookUp(Cities,Title = TextInput9.Text).ID,Value:LookUp(Cities,Title = TextInput9.Text).Title} })
Here, I have created a similar scenario to patch the updates.
TextInput4 holds the employee Name, TextInput9 is the textbox beside Submit button to hold the new Value.
As per my Employees SP list, I have stored Names in the title, so if you want to match with some other column, please update the column name in lookup query.
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you l

Was this reply helpful? Yes No
SushReus 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Yuxima,

It is not yet resolved can you please help me out.
@v-yuxima-msft wrote:
Hi @SushReus

Could you please test with @yashag2255 's suggestion?
Is it solve your issue?

Best Regards.
Yumia

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@SushReus

Yes, City is a column of type choices.

Please share details about your SP list and the type of column, through this we will be able to help you better.

Was this reply helpful? Yes No
SushReus 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Yash,

The CIty Column in Employees SP List is a lookup column which is from another SP List Cities .

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @SushReus

Please share the formula for OnSelect property of your button. I tried the same scenario as yours and it was updating successfully, so might be possible it is some minor formula level mistake.

Was this reply helpful? Yes No
SushReus 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Patch(Employees, LookUp(Employees,Title = TextInput1.Text),
{
City:{Id: LookUp(Cities,Title = TextCol.Text).ID,Value:LookUp(Cities,Title = TextCol.Text).Title}
})

and

Patch( Employees , ThisItem , { Title : TextInput1.Text , Colour : Dropdown1.Selected , Department : TextDept.Text , Dist : TextColor.Text, Town : TextCol.Text })

Was this reply helpful? Yes No
SushReus 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I would Require another Help

Need to Update a look up column for the below given Scenario

I want to Update my SharePoint List HELP DESK (Column - Category which is a look up column) using Patch with the Detail I give in Category Text Box whose value is dependent on Drop Down ddCategoryType . (Have a look at the screenshots)

Drop Down ddCategoryType is populated from SharePoint List CategoryOptions

Was this reply helpful? Yes No