Showing results for 
Search instead for 
Did you mean: 
Not applicable

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. 



Power Apps
Power Apps

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

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,064)