How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action

Do you hate how the List rows present in a table action requires you to specify a Table in your Excel file?

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
---
SKIP AHEAD:

0:00 Intro
0:19 Build the Flow
1:38 Avoid the Apply to Each Action
2:56 Get the Content with an Expression
3:51 Get the Content with a Parse JSON Action

#sharepoint #sharepointonline #powerautomate #learnonyoutube #microsoft365 #microsoftpowerautomate #microsoftflow #powerplatform #productivityhacks #productivitytips #onboarding #workflowautomation #microsoftexcel #exceltips #exceltipsandtricks

SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH

---
Teaching you how to make your workflows SUCK LESS.

Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.

Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.

Get curious. Be creative. Do better.

---

FOLLOW ME:

[LetsChat]

THIS IS WHAT I NEEDED. Brilliantly laid out. I used the first half and merged it with the flow I'm currently working on. What a great walkthrough!

[jmrendel]

This has been really helpful to me.. however, I've also found that if you know what the table's name is, you can just add that in a "compose" step and dynamically refer to it later in the flow.

[bradcover]

You are awesome - been looking for a solution like this forever, thank you!!

[Argentinian]

Hi! Flow Fiesta was here. Thank you so much for your help. I'll have to watch the video several times because I didn't quite understand. I'll also check out the introductory videos. Thanks again!
P.S.: Very nice voice!

[enigmaume]

I do not know who you are but wow, you solved all of my problems in one go, right from parse json to how you did the tables, thank you, if there is in anyway i can contribute and thank you, please do reach out.

[aboelyoos]

🎯 Key Takeaways for quick navigation:

00:00 *💡 Setting up Power Automate Flow*
- Demonstrates setting up a Power Automate flow to add items to a SharePoint list whenever a new file is added to a folder in Microsoft Power Automate.
- Creating an automated cloud flow triggered by the "When a file is created (properties only)" trigger.
- Utilizing actions like Compose, Get tables, and List Rows Present in a Table to set up dynamic table selection and data processing.
01:34 *🔄 Avoiding Apply to Each Action*
- Explanation on avoiding unnecessary Apply to Each action when dealing with a single table in an Excel workbook within Power Automate.
- Demonstrates how to specify the first table name returned by the Get tables action to avoid Apply to Each.
- Provides guidance on using expressions to dynamically select the table and handle array positions.
03:11 *🛠️ Processing Data from Excel Table*
- Strategies for processing data from an Excel table using Power Automate.
- Explains two methods to return content from the List Rows Present in a Table action: using expressions or the Parse JSON action.
- Demonstrates setting up the Create Item action to process data from the Excel table and create SharePoint items.

Made with HARPA AI

[mathiasgarden]

If you get an error in the Get tables action due to file name, you can use the Identifier variable from the sharepoint trigger instead.

[PedroHenrique-dndj]

Pretty nice viceo and everything seemed to work out quite nicely for me. However when I try to get the file path straight from a "file created" from one drive it gives me an error of file not found, even though the input it is exaclty the same thing as when I try to rerun the flow, but selecting the already created file from the folder.
Does anyone know if there's any isue with dynamic inputs from onedrive for any reason?
Besides, if any one is having to download the output of the 'list rows' action, be aware to get only the 'value' part of the content as it'll be presented with the 'body' of it and the flow will give an error.

Thanks!

[tsnscej]

this is exactly what I needed, thank you!
So frustrating how the tables' values are only shown if the table stays static.
At the end, you enabled currency control, could you please explain the value of currency control?

[efeherek]

Thanks for your amazing guide but I couldn't figure out how to update the item is the value is changed on that excel. It just didn't work with get items because it is dynamic. I am using when a file is created or modified

[jisbelking]

Nice description, thanks!

Only one thing is unclear: How do I find out the table index in an array? (2:05 in this video). If I have multiple sheets with multiple tables each, does PowerAutomate sort them in the same order as I see the sheets in my file? Is it 1) left to right and 2) top to bottom within one sheet?

[SherylPeralta-psxo]

Hello
Thank you for the incredible tutorial, however what If I have multiple tables, but only need one that has a specific value (case file #), tables are divided by month and each month has completely different cases, the case is pulled from a google form so it changes everytime

[ABDOUDIALLO-gxum]

Hey, Thank you so much for the great content! What would be the process if the list doesn't exist in the sharepoint ? Thanks for guiding me

[vcp]

I love your videos so much! If you are able to answer this question, I will love you forever!
Rather than creating an item in a sharepoint list like you demonstrated, I want to update an existing item from a list. I added a Get Items since I had to reference a sharepoint list, but when completing the "update item" step, I reference the Get Items ID, and then an apply to each is created with the sharepoint value, instead of the Parse JSON. Do I need to create a compose for the get items ID?

[rogerlopez]

exactly what I was looking for, thanks for you videos!

[noodlebrains]

Curious why you did create item rather than update row with the Json

[SIATECH]

thank you for the video, why you tunned on the Concurrency Control as the last step?

[claudiaricalde]

HELLO! I LOVE YOUR VIDEOS! Im struggling trying to figure how to convert a CSV in .xlsx i think im very close to but i dont know yet :'*)))) is there any video with that explanation? thanks again for your time
:D

[Romenet]

can I use something similar to this to count the rows?

[xuewenng]

Hi, how could I done this to my excel file in one drive ? Thanks thanks <3