Thank you! It works (mostly). Is there a way I can enable the action to filter it even more? At the moment it filters by date which is great, but it returns all rows associated with that date. Can I also have it so that it not only filters it down to the date but also if the indicator column in my data set equals "No"?
If not, that's ok. It might be better off performance wise to just add a filter on that worksheet since I'm dealing with millions of rows every day.
Can you share a sample workbook?
One way you can filter by "No" is by applying filter to your details sheet or including "No"`s in your primary/ source view- this will allow you to filter your details view.