Thank you for the feedback Dan. I find real world use cases a bit more interesting as they bring unexpected complications. Glad you are enjoying the videos.
Hi Paulie, thank you SO MUCH for this video. I am brand new to Power Automate and have been trying to extract table data from hundreds of emails for WEEKS now. This video has solved my problem. I cannot thank you enough.
I rarely comment on people's videos but thank you so much for this VERY informative video. Whether you are a novice or need a refresher cuz you haven't done it in awhile (ME lol), this will help you with useful expressions which can be tricky at times. Thank you so much!!!
@@PaulieM Hi Paulie, I'm getting an error on the very last part. Are you able to help? 'The template language expression 'split(item(), '^')[3]' cannot be evaluated because array index '3' is outside bounds (0, 2) of array.
Uau, great job!! Thank you very much for the didactic explanation! Best of all about filtering content and handling text efficiently in Power Automate.
Thanks a lot. it helped me a lot in my learning period . I am new to power automate and it is in such more details explanation and with examples. which helped me in my project.
Hello Paulie thank you very much for this video. I'm new to power automate can you please advise me how can I select table 2 or 3 after the using the split?
Hi this video is really helpful... But I'm looking for a way to have table headers dynamically. Maybe My table will have 4 or 5 or 3 columns only. So How can we bind the array of headers and . I'm able to get column headers into separate array and respective rows into separate. But unable to bind them into one Select Action to make json
Nice one Paulie, spot-on content :) I have a question Is it possible to extract from a .html file saved in SharePoint or email attachment .? Many thanks
Hi. First of all, thank you very much for a thorough walk of the process. I was struggling with this for a couple of days until I found your tutorial. For the step of mapping, I used a loop to dynamically create JSON items since the user might add stuff to the table and I didn't want my output to break because of that. So in my mapping in 'select;, I used this: split(item(),'^')[0], and element [1] as value. It worked for me, but I was wondering if there is a better way of doing this? Also a question. How can i return the JSON that i got after the 'select' action so i can use it further on?
The output of the select action should be available in your dynamic content. You could use a parse json step after the select action - it would make things easier for you to reference.
@Paulie M thank you for your response. I was able to fetch the output and cureently struggling with parsing :) However, as a workaround, i used the condition block and am checking in a loop if the item contains the value. I would assume there should be a way to fetch values from the json obj, but im too beginner to that right away :)
Hi Paulie, This was wonderful presentation unlike any other I have seen here. Have become a new subscriver now! Just two important qs: 1) How do I remove any row during the 'Row' stage, For example I have one non-empty row in the end? 2) How can i append the output without the headers. Like I have already the headers in one excel file but simply want to append every output below the headers? Thx!
Hi Pauline, Great video. Just like others I'm also facing the same error The template language expression 'split(item(),'^')[1]' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Any suggestions?
I would think it would be easier to get every row, and then use the "Take" expression in a compose action to get only the first 5 rows of output. Does that make sense?
hey Paul, what if you have a table that has questions in column A and the answers in column B ? how would you make the JSON then if you are not using the column headers for the output?
now im stuck trying to write this into an existing table within an excel template i have stored in sharepoint which then saves each table as a seperate excel spreadsheet which i plan on using each of these further to populate a master spreadsheet.
Hello Paulie, I was following your video and doing step by step, everything was going well until I used the html to text connector. I got this alert "The flow was saved, but it couldn't be enabled because it contains connectors to apps that don't support the Gmail connector used in this flow" Do you know of a way to do that step differently? Thank you very much in advance for the video
Such a helpful video! If it works for me it would be so amazing. I completed all the steps of the video but i am not sure how to get the individual data points from the select step into Sharepoint items. I add the "create list item" and put the select item output in each of the columns. but it doesnt work. wouldn't i have to tell the flow which select item to put in the sharepoint field? seems odd putting the same thing in each. Your help (more of it, that is) would be so appreciated. AA
Your videos are a life saver! But i'm getting an issue indexing anything other than element 0 on the Select step. It gives me error message: The template language expression 'split(item(), '^')[1]' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Can you suggest anything I should check? I followed your other steps religiously. Thanks!
Hi @Paulie, i am trying the step and getting error 'cannot be evaluated because array index '1' is outside bounds (0, 0) of array' on action: Select after filter array. The split expression 'split(item(),'^')[1]' onwards is not working but split(item(),'^')[0] is giving result. any thought?
@@PaulieM yeah but it can only happen when you have fix no. Of columns because you are indexing them. What if i don't know the number of columns that how many columns are coming from email table. how will I use indexing in that scenario??
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IwRKWaTnl3U.html "There is a fancier way of doing this..." What is this method? With the new editor layout, I'm struggling a little to do this step to remove the slash N's.