Power Automate Trigger With SmartSheet Report

Is it possible to use Power Automate to Trigger a Flow with a Report From SmartSheet? I was able to do it with a sheet, but not the report.

I am using a report to group multiple sheets together with a field with a certain status. I need to run a Power Automate Flow as soon as a record gets that status and gets moved to the report.

Again, I was able to get this to work by using a Sheet and manually adding a new record, but since those records already exist and only have their status updated, I need to keep them in a report.

Any ideas on how to accomplish this?

Answers