How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action
Vložit
- čas přidán 31. 07. 2024
- 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
👉 bit.ly/SubACreativeOpinion 👈
---
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:
/ acreativeopinion
/ acreativeopinion
/ acreativeop
You are awesome - been looking for a solution like this forever, thank you!!
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!
Thanks for watching and for the feedback!
exactly what I was looking for, thanks for you videos!
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!
You're welcome! Thanks for watching!!!
Love You!!! Thankyou so much!
🎯 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
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
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.
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.
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
Thanks, it worked for me
Thanks! Your video is amazing
Thanks for watching! 😊
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.
Thank you so much for watching. Glad to hear this video helped you.
You can also contribute by giving me a 💖 Super Thanks or ☕️ Buying me a Coffee: www.buymeacoffee.com/acreativeopinion. Much appreciated 💕!
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
Curious why you did create item rather than update row with the Json
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?
Thanks for watching!
Take a look at this section of a different tutorial where I explain the Concurrency Control: czcams.com/video/68fA0S65AUk/video.html
When you say "table's values" I'm assuming you are referring to the dynamic content. This can happen in a few different scenarios. One common scenario is when using a Filter Array action. Most times, the dynamic content isn't accessible through the dynamic content list and has to be accessed with an expression. If you use a Filter Array action in your flow, refer to this section of a different YT Tutorial on how to get the dynamic content from the Filter Array action: czcams.com/video/HVAf1aTEQNg/video.html
Hope this helps!
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?
Thanks for watching! The Get Items action will always return an array of items. Even if it's a single item-this is why the Update Item action gets automatically nested inside an Apply to Each action.
Please refer to this tutorial - 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow: czcams.com/video/44Bk4JVMrD4/video.html
I cover how to avoid the Apply to Each action with an expression. Hope this helps!
Thank you so much! I can’t wait to apply this to my flow. ❤
thank you for the video, why you tunned on the Concurrency Control as the last step?
Thanks for watching! I usually turn it on at the end but you can feel free to turn it on whenever you'd like.
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
Thanks for watching! There is probably a premium connector that would allow you to easily convert a CSV to an XLSX file. However if you are looking for a way to accomplish this without a premium connector you would need to Parse the CSV file and individually add the rows of data into an excel table. Hope this helps!
Hi, how could I done this to my excel file in one drive ? Thanks thanks
Thanks for watching. In the List rows present in a table action, you can select OneDrive for Business as the location. Hope this helps!
can I use something similar to this to count the rows?
Thanks for watching. If you want to count rows from the List Rows present in a table action, you need to use an expression. I cover how to do this in this section of one of my other YT Tutorials: czcams.com/video/jqYgn6MFD94/video.htmlsi=b3wwOE2_VyCYpqXg&t=318
Hope this helps!
what is the Voice Ai used in this video please?
I didn't use a voice AI. 😊
@@acreativeopinion Your voice sounds more like generated with AI, rather than natural or human but i like it it so clear
Thanks?! I think? 😳