cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mchapman
Level: Powered On

Re: How to patch a SharePoint Lookup Column

Well, I tried and I just couldn't get it to work.  So I decided on a diffrent strategy.   Instead of trying to set it to blank, set it to a default value and then enter that default value into the source table the lookup column is based on.  Works like a charm...

Stijn007
Level: Powered On

Re: How to patch a SharePoint Lookup Column

hello, @v-micsh-msft 

 

I have a simular case. (Patch to lookup columns in sharepointlist.) 

The user selects an item in the browsegallery and he will be navigate to an editform. 

Because I changed the item function of the dropdowns in the editform, the submitform function doesn't work any more. (I suppose that's the reason. )  

 

I tried to use your formula but there is still something wrong. This is what I use on the onselect function from an icon (to save) 

A second question is how to use it for multiple dropdowns. This editform has 4 dropdowns each to patch to a lookup column.

 

 

Navigate('Screen CMT NIV 3';ScreenTransition.None) ;;
Patch('CMT Niveau 3';
'BrowseGallery CMT Niv3'.Selected; 
{Lookup:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
Id:'BrowseGallery CMT Niv3'.Selected.Id;
Value:'BrowseGallery CMT Niv3'.Selected.'B-TO'.Value }
}
)

Stijn007
Level: Powered On

Re: How to patch a SharePoint Lookup Column

I figured out to Filter The choices of the dropdown based on the value in another list. 

Then I could use submitform again and i don't have to patch. 

 

 

Helpful resources

Announcements
thirdimage

Power Platform 24

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,600)