Hey all,
I've been working on a script to pull data from our vulnerability scanner into an Excel file, format it, and create Planner tasks for each row in Power Automate. However, I'm having some issues with the name of the table I created not registering properly - I've tried creating a variable for the name and using it as a stand-in, but I'm still running into an error where Automate can't find the table I'm pointing it to. Does anyone know why this might be occurring or have a suggestion for a workaround?
Error details: Action 'List_rows_present_in_a_table' failed
-> No table was found with the name 'Table1'
I'm especially confused because the output for my variable is correct (and Table1 is passed in as input to List Rows Present in Table)
Full flow
Granular detail - grab variable, list tables
Set table name to variable
List rows in table - ERROR!
Pre-run sanity check