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!
🎯 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
hi i've created a new file with a table and I'm trying to add list row in a table. as my table name is dynamic I can't see the column fields available in the excel table.
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
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?
Thanks for watching. Run a test after you add the Get Tables action to your flow and review the outputs. Alternatively you can add an Apply to Each action (for testing purposes) after the Get Tables action. Insert a Compose action to output the Name dynamic content from the Get Tables action. Run a test and review the outputs. When you do this you will see that the tables are listed by sheet order, then by table order. However because you have multiple tables in each sheet it would be best to use a Filter Array action instead of an index key. Use the Filter Array action to filter out the name of the table you are looking for. To learn more about the Filter Array action, refer to this YT Tutorial: ua-cam.com/video/HVAf1aTEQNg/v-deo.html
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
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!
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 💕!
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: ua-cam.com/video/68fA0S65AUk/v-deo.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: ua-cam.com/video/HVAf1aTEQNg/v-deo.html Hope this helps!
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.
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: ua-cam.com/video/44Bk4JVMrD4/v-deo.html I cover how to avoid the Apply to Each action with an expression. Hope this helps!
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!
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: ua-cam.com/video/jqYgn6MFD94/v-deo.htmlsi=b3wwOE2_VyCYpqXg&t=318 Hope this helps!
You might be interested in this YT Tutorial: ua-cam.com/video/GNLhPqP1cjM/v-deo.html In this video tutorial I will show you how add a script to Excel that will format all of the data in your entire workbook into tables. You can even customize the table style. This time saving automation will allow you to quickly create multiple tables with a single click. Hope this helps!
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!
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!!!
You are so amazing omg. Ive been struggling FOREVER until i saw your video. Thank youuuuuuuuu🥺💙😭
🎯 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
You are awesome - been looking for a solution like this forever, thank you!!
exactly what I was looking for, thanks for you videos!
hi i've created a new file with a table and I'm trying to add list row in a table. as my table name is dynamic I can't see the column fields available in the excel table.
This is Dope. Saved countless hours of hit and trial 👌👌
Amazing! Thanks for watching!
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
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
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?
Thanks for watching. Run a test after you add the Get Tables action to your flow and review the outputs. Alternatively you can add an Apply to Each action (for testing purposes) after the Get Tables action. Insert a Compose action to output the Name dynamic content from the Get Tables action. Run a test and review the outputs.
When you do this you will see that the tables are listed by sheet order, then by table order. However because you have multiple tables in each sheet it would be best to use a Filter Array action instead of an index key. Use the Filter Array action to filter out the name of the table you are looking for.
To learn more about the Filter Array action, refer to this YT Tutorial: ua-cam.com/video/HVAf1aTEQNg/v-deo.html
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
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!
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 💕!
Hi there. Nice video. When I go for the peek code I see "table":" " so there is no name in the quotes. Thank you for your help.
Thanks for the video, really helpful 👋
Thanks so much for watching!
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: ua-cam.com/video/68fA0S65AUk/v-deo.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: ua-cam.com/video/HVAf1aTEQNg/v-deo.html
Hope this helps!
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.
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.
Curious why you did create item rather than update row with the Json
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.
Thanks! Your video is amazing
Thanks for watching! 😊
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: ua-cam.com/video/44Bk4JVMrD4/v-deo.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!
Love You!!! Thankyou so much!
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!
Thanks, it worked for me
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? 😳
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!
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: ua-cam.com/video/jqYgn6MFD94/v-deo.htmlsi=b3wwOE2_VyCYpqXg&t=318
Hope this helps!
...and the problem a lot of us have is not all spreadsheets have tables.
You might be interested in this YT Tutorial:
ua-cam.com/video/GNLhPqP1cjM/v-deo.html
In this video tutorial I will show you how add a script to Excel that will format all of the data in your entire workbook into tables. You can even customize the table style. This time saving automation will allow you to quickly create multiple tables with a single click.
Hope this helps!