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

How to patch all gallery items?

I tried patching a SahrePoint list, with this formula

 

ForAll(ReqItemsGallery.AllItems, Patch('Requisition Form',Defaults('Requisition Form'), {Request_x0020_Status: "Submitted"}))

 

ReqItems.Gallery are filtered, and I wanted to patch the column Request Status (single line of text) for all the items in this gallery. But, new items are created in the SharePoint list instead of patching the items. Please anyhelp is really appreciated! 

1 ACCEPTED SOLUTION

Accepted Solutions
MoniqueTrinidad
Level: Powered On

Re: How to patch all gallery items?

Found the solution, Smiley Happy

 

ForAll(ReqItemsGallery.AllItems, Patch('Requisition Form',{ID: ID}, {Request_x0020_Status: "Submitted"})))

2 REPLIES 2
MoniqueTrinidad
Level: Powered On

Re: How to patch all gallery items?

Found the solution, Smiley Happy

 

ForAll(ReqItemsGallery.AllItems, Patch('Requisition Form',{ID: ID}, {Request_x0020_Status: "Submitted"})))

MoniqueTrinidad
Level: Powered On

Re: How to patch all gallery items?

Please help, this time, how to patch all items for a subgallery? I have a Gallery (ReqGallery) that contains a subgallery (ReqSubGallery), used GroupBy to populate the galleries. I wanted to patch the SharePoint column Request Status (single line of text) for all the subgallery items of the selected item in my main gallery.

 

ForAll(ReqGallery.Selected.ReqSubGallery.AllItems, Patch('Requisition Form', {ID:ID}, {Request_x0020_Status:"Approved"}))

 

Tried this, but it does nothing. 

 

I cannot simply patch the column Request Status for the main gallery selected item as my data is grouped by a diff column. Please help!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

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

Users Online
Currently online: 261 members 5,623 guests
Please welcome our newest community members: