Update Multiple CDS records from Gallery

(0) Share

Report

Posted on by tjalui

145

Hi,

I have a requirement to update multiple records selected in the gallery.

I am using CDS as Data Source.

In the App there is a checkbox, to update multiple records the user will click on the checkbox.

There is a save button on which I have the following formula

ForAll(
 Filter(
 GalleryQuoteProduct.AllItems,
 CheckboxQuoteProductGallery.Value = true
 ),
 Patch(
 [@'Quote Products'],
	'Quote Product' in Filter(
 GalleryQuoteProduct.AllItems,
 CheckboxQuoteProductGallery.Value = true
 ).'Quote Product',
 {
		'Product Name': ProductNameQPGallery.Text,
	 'Product type':ProductTypeQPGallery.Selected.Value,
		'Price Per Unit': Value(PricePerUnitQPGallery.Text),
		Quantity: Value(QuantityQPGallery.Text),
		'Manual Discount': Value(ManualDiscountQPGallery.Text),
		'Extended Amount': Value(ExtendedAmountQPGallery.Text)
 }
 )
)

Any help will be appreciated

Categories:

Building Power Apps