Power Automate List Rows in Table Error

Question

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:

More Detail:

Before Running:

Answer 1

Hi Jonah,

Thank you for querying in this forum.

From your description, it seems that you are using Microsoft flow to create Planner tasks for each row in Excel. And you encountered some issues when you created a variable for the name and using it as a stand-in.

If my understanding is right, we’d also want to help you, since our category focus on SharePoint Online built-in features, the question you mentioned is related to Microsoft Power Automate, to make sure you get professional help, we’d you go to  Power Automate Community to post a new thread. Which is specific channel to handle related questions. And engineers in that forum will focus on your specific scenario and provide specific suggestions.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Best Regards,

Sukie