cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino
Level 10

Solved: patching to SharePoint choice and lookup type columns

The following should work if you disallow multiple selections for the column in SharePoint.

 

Any updates will be in this newer post.

 

I will start with choice type columns, but the approach is exactly the same for lookups.

 

Let's say your SharePoint list (MyList) has a choice column (MyChoiceColumn) with 3 choices: Choice A, Choice B, Choice C.

 

This works:

Patch(MyList, MyRecord, {MyChoiceColumn: {Id: 1, Value: "Choice A", '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}})

 

In order to make it practical, have a dropdown control (Dropdown1) in PowerApps with the following Items property:

Table({Id: 1, Value: "Choice A"}, {Id: 2, Value: "Choice B"}, {Id: 3, Value: "Choice C"})

 

Then you can modify the above Patch to this:

Patch(MyList, MyRecord, {MyChoiceColumn: {Id: Dropdown1.Selected.Id, Value: Dropdown1.Selected.Value, '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}})

 

If you have a lookup to MyLookupList with MyLookupColumn, then set the Items property of the dropdown control to this:

MyLookupList

(you must have also added this list as a data source first)

 

Then the Patch will be this:

Patch(MyList, MyItem, {MyLookupColumn: {Id: Dropdown1.Selected.ID, Value: Dropdown1.Selected.Title, '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}})

Please let me know if anyone has any issues with making this work.

4 REPLIES 4
TimoPertila
Level: Powered On

Re: Solved: patching to SharePoint choice and lookup type columns

What is "MyRecord" in this solution?

Meneghino
Level 10

Re: Solved: patching to SharePoint choice and lookup type columns

MyRecord is a record or record type variable which identifies the record to be modified.

It need only contain those columns in the primary key of your data source.

Please let me know if further clarifications are needed.

Highlighted
madimad
Level: Powered On

Re: Solved: patching to SharePoint choice and lookup type columns

iam trying i have choice column but its giving me error on record . tried alot 

seadude
Level 10

Re: Solved: patching to SharePoint choice and lookup type columns

Hi @Meneghino. How does this method apply when Patching multiple records to a Sharepoint Person-type column? I can't seem to get this part to work.

Example:

  • Sharepoint data source
  • Using a Person-type column for one Form field
    • This column allows me to lookup people within my org AND select multiple.
  • I just can't figure out how to write the Patch statement for this. "Odata" is a bit baffling to me. I need to research more.

Thank you

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 277 members 4,707 guests
Please welcome our newest community members: