Table not found exception in filter table activity

Help Activities
, , , ,
1

Dear All ,
I am trying to filter a excel table , which is a pivot table but filter table activity throws , not found exception.
What might be the issue ? Please refer the following pictures

filtertable issue2
filtertable issue21969Γ—1031 160 KB

filtertable issue 1
filtertable issue 11920Γ—1033 104 KB

Thank You !

2

We do have a table when it looks like this

grafik

an is created by insert Table Command and defining the table name.
Check in Excel on Ribbon Formula β†’ Name Manager if Table1 is existing in your Excel
grafik

3

Hii @ppr

Yeah and I have got is a Pivot table , so will I have to convert it into a table too ? will it possible ?

Thank You !

4

당신이 λ§Œλ“  μ˜ˆμ œνŒŒμΌμ„ μ—…λ‘œλ“œ ν•΄ 쀄 수 μžˆλ‚˜μš”?

5

lets do one by one:

the error on table name not found was adressed with first feedback from above. Is it gone?

To continue rhe work on filtering it depends to your requirements / what is to filter. It has the risk to lose the groups and maybe can be handled better within filtering on datatable base after readin excel with read range and some postprocessing

6

Hii @sumouse
For the sake of Google lense , I could able to understand what you said :joy: :joy:

Sure , here is the project file that I created.

Main.xaml (7.8 KB)

Thank You !

7

https://blog.naver.com/sumouse/222464253230