cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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...

Highlighted
Helper III
Helper III

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 }
}
)

Highlighted
Helper III
Helper III

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,505)