Unable to select existing sheet1 tab from Excel in PA

[asen55]

Hello,

I am receiving the following error when trying to select a "Table" field, which I am assuming is referring to the spreadsheet Sheet1 tab.  It doesn't automatically populate any fields when I click the dropdown, and if I put in Sheet1 for the value, I receive the following error.  I am using an existing spreadsheet saved to my OneDrive.  Any help is greatly appreciated!

[creativeopinion · Accepted solution]

@asen55 The List Rows Present in a Table action requires your Excel data to be formatted into a table. Select a cell and click on Format as Table.

If you are interested, I cover how to get a dynamic table in this YT Tutorial: How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action

In this Microsoft Power Automate tutorial, I’ll show you how to dynamically set the File and Table field.

IN THIS VIDEO:

✅ How to create an Automated Cloud Flow

✅ How to dynamically select a Table in the List Rows Present in a Table Action

✅ How to use the Parse JSON action

✅ How to use the When a file is created (properties only) trigger

✅ How to avoid the Apply to Each Action

✅ How to Create an Item in SharePoint from Excel Data

--

You might also be interested in this YT Tutorial: ✌️TWO WAYS to Get Data from Excel into a SharePoint List

There are two ways to get your data from Excel into a SharePoint List:

1️⃣ Copy and paste

2️⃣ Automatically with a Power Automate flow

In this video tutorial I will show you how to get your Excel data into a SharePoint List using the two methods listed above. I’ll cover how to format your data for complex columns such as a multi-choice and multi-person columns.

---

IN THIS VIDEO:

✅ How to copy and paste data from Excel into a SharePoint List

✅ How to format Excel data for multi-choice columns in a SharePoint List

✅ How to import data from Excel into a SharePoint List with a Power Automate Flow

✅ How to use the Select action in Power Automate

✅ How to use the Create Item action in Power Automate

✅ Enabling the Concurrency Control to Optimize Flow Performance

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[AlexEncodian]

@asen55 if your data is not in a table (e.g. if the file is a system output), then you can also use Encodian's Get Rows from Excel action.