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

Update row in excel when list control has filtered and distinct data

I have a data model in excel with repeated rows by few columns. row update and delete is working if i don't apply filter or distinct in list control in prev screen. 

How can i update selected row from prev screen list control when list control has filtered or distinct data. 

 

my formula for filter as follows:

ShowColumns(Filter(Table2, Company=TemplateGalleryList1.Selected.Result, Department=TemplateGalleryList2.Selected.Result),"Team_x0020_Member_x0020_Email_x0020_Address","Team_x0020_Member_x0020_Name", "Title", "Session_x0020_Date","Session_x0020_Time")

 

i am attaching a excel data model here and in that model i am applying filter and distinct on company and department column. 

 

image.png

1 REPLY 1
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Update row in excel when list control has filtered and distinct data

If you only have filtered data (in a gallery, I assume), then updating the row should work, as the "shape" of the records isn't changed on a filter operation. What kind of error are you getting, and how are you trying to update the Excel row, using a form or the Patch function?

 

For Distinct data, what is the formula that you are using, and how are you trying to update the Excel row?

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,779)