cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RishiBhutani
Level: Power Up

Edit Table Grid Advanced Features

We are looking for Editable Grid Funcationalilties:

1. Bulk Edit

2. Bulk Validate

3. Bulk Delete

4. Advanced Filtering - OOB

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Edit Table Grid Advanced Features

Hi @RishiBhutani ,

Do you mean that you want these 4 functions :Bulk Edit, Bulk Validate, Bulk Delete,Advanced Filtering?

About "Bulk Edit, Bulk Validate, Bulk Delete", I suggest you try ForAll function.

Combining ForAll function with orther functions will achieve what you want.

You could try:

Bulk Edit : ForAll and Patch

Bulk Validate: ForAll and IsMatch

Bulk Delete:ForAll and Remove

For example: update multiple records.

Collect(collection1,the items that you want to edit);
ForAll(collection1,Patch(tablename,LookUp(tablename,ID=collection1[@ID]),{fieldname1,.....,fieldname2:....})
//in this way, you could update multiple records at the same time

Here's a doc about it in details for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

About "Advanced Filtering", could you describe more clearly aboout the function?
What's your data source?What's the data type?What do you want to filter based on?

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Edit Table Grid Advanced Features

Hi @RishiBhutani ,

Do you mean that you want these 4 functions :Bulk Edit, Bulk Validate, Bulk Delete,Advanced Filtering?

About "Bulk Edit, Bulk Validate, Bulk Delete", I suggest you try ForAll function.

Combining ForAll function with orther functions will achieve what you want.

You could try:

Bulk Edit : ForAll and Patch

Bulk Validate: ForAll and IsMatch

Bulk Delete:ForAll and Remove

For example: update multiple records.

Collect(collection1,the items that you want to edit);
ForAll(collection1,Patch(tablename,LookUp(tablename,ID=collection1[@ID]),{fieldname1,.....,fieldname2:....})
//in this way, you could update multiple records at the same time

Here's a doc about it in details for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

About "Advanced Filtering", could you describe more clearly aboout the function?
What's your data source?What's the data type?What do you want to filter based on?

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 159 members 5,986 guests
Please welcome our newest community members: