I am having trouble filtering my data. I am using a flow to create a table. The data needs to be filtered down to 3 specific sites that have the status 'Cancelled'
My current flow will create the table but it will not filter down to my 3 sites. Please see my Filter array formula I have used below and a snip of my flow. I have tried it in the filter query of the "Get Items" action but get an automatic fail.
@Anonymous(equals(item()?['Site'], 'Name'), equals(item()?['Site'], 'Name'), equals(item()?['Site'], 'Name'))
Can you please help me so I am able to filter to the 3 unique names?
