Quite useful. Thank you so much. Question: What if you want to extract data whenever a new email arrives and the table data varies in the number of rows? i.e one email might have one row of data and another might have 2 or even more rows?
Hello, Everything else works, except for when you filter out the empty variables from array. For some reason, when i put in the filter, it says Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(lenght(item()), 0)' failed: 'The template function 'lenght' is not defined or not valid.' Instead, i used Filter array expression @equals(empty(trim(item())), false), which works beautifully. Not sure why the lenght variation doesn't work.
Hi Paulie. I wanted to understand more about this content. I have this flow that I wanted to create. It involves a table coming from the body of an Oulook Email and tranferring the table data into MS Excel. I hope you could help me! Cheers! 🥂
How to extract the data from Dataverse into xml file.. I have two dataverse tables related and I need to extract the data from both of them into xml.. is that possible?
Hi Pauli, I am having SAP report coming in my email as an HTML file .htm extension. I want to conert it either in JSON or CSV or Excel so as to read it in dataverse. please guide
@@PaulieM the attachment I am getting is SAP report of more than 10MB and HTML to text doesn't work for this much file size; so at first step itself I am stuck.
@@nilpr You will probably need to do some operations on the file before you can work with it. This is a more complicated scenario. You will need to reach out to me via my blog.
I emails get everyday that contain tables, I need to track this table information in Excel, date, items, qty...etc. I've tried to follow along, but I don't code and this is so confusing. I really want to automate this process as it will be a huge time saver... can you help me?
Would you mind posting the code? every time I try to get rid of the new line, it says my expression is invalid, and I'm not sure what I'm doing wrong. Thank you so much for posting this btw!!!
Can you share your email id, i want to share my situation. I am working from last almost month to find out solution, its an HTML table i get from email which further need to add in Excel to create tracker. but when i convert html data into plain text it removes all the spaces between the Raws and den i lost to find further steps to proceed on.
Exactly what I needed. Love your channel!
Thank you very much for this. I was looking for this solution for 2 weeks.
Glad it was helpful to you.
Thank you for sharing the video. Please do create more videos like this. I would love to see more examples of how to use Power Automate.
My pleasure, should be a new one coming today. If you have something you’d like to see explained let me know and I will try to cover it.
@@PaulieM I'm trying to use MS Forms and all responses to fill out in a PDF template. Is that possible?
@@anniekostadinova7915 yes, it’s possible. Do you have a Power Automate Premium license?
@@PaulieM yes, I do
@@anniekostadinova7915 we can build it together if you like. Record it and I will publish as a TH-cam video 👍🏻
You are a real hero! A real one!
Ha ha, thank you!
Great video Paul, for a scope that seams esay, but not. Thanks a lot!
Thank you so much. You are the best. Greetings from Perú 🇵🇪
Thank you Luis - lots more content coming soon!
This video helped me a lot, thank you Paulie
Amazing stuff..thnx for sharing
Thank you!
Thank you for Sharing, great content.
My pleasure, glad you found it useful.
Quite useful. Thank you so much. Question: What if you want to extract data whenever a new email arrives and the table data varies in the number of rows? i.e one email might have one row of data and another might have 2 or even more rows?
Thank you so much dude. It resolved my issue
Very happy that you got the solution you needed.
Great Video! I'm lost though on how to go from the final action "Select" to Insert Row into excel. Any thoughts?
Hello,
Everything else works, except for when you filter out the empty variables from array. For some reason, when i put in the filter, it says Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(lenght(item()), 0)' failed: 'The template function 'lenght' is not defined or not valid.'
Instead, i used Filter array expression @equals(empty(trim(item())), false), which works beautifully. Not sure why the lenght variation doesn't work.
Very very nice, thank you very much!
You’re very very welcome!
Hi Paulie.
I wanted to understand more about this content.
I have this flow that I wanted to create. It involves a table coming from the body of an Oulook Email and tranferring the table data into MS Excel.
I hope you could help me!
Cheers! 🥂
Which part are you stuck with?
How to extract the data from Dataverse into xml file.. I have two dataverse tables related and I need to extract the data from both of them into xml.. is that possible?
I tried the HTML to text action but it couldn't pickup the column names in the email
What if the value of one of the columns in the array comes as null. How to handle that
Hi Pauli, I am having SAP report coming in my email as an HTML file .htm extension. I want to conert it either in JSON or CSV or Excel so as to read it in dataverse. please guide
Which part of the video was unclear - where are you stuck?
@@PaulieM the attachment I am getting is SAP report of more than 10MB and HTML to text doesn't work for this much file size; so at first step itself I am stuck.
@@nilpr You will probably need to do some operations on the file before you can work with it. This is a more complicated scenario. You will need to reach out to me via my blog.
I emails get everyday that contain tables, I need to track this table information in Excel, date, items, qty...etc. I've tried to follow along, but I don't code and this is so confusing. I really want to automate this process as it will be a huge time saver... can you help me?
If you get in touch via my blog I will see if I can help you sort it.
Would you mind posting the code? every time I try to get rid of the new line, it says my expression is invalid, and I'm not sure what I'm doing wrong. Thank you so much for posting this btw!!!
@paluie M pls make video on power automate desktop (RPA) as i don't find good solutions available on youtube for that.
thanks, very nice. Now I need get data within excel, how to do it...¿?
Can you share your email id, i want to share my situation. I am working from last almost month to find out solution, its an HTML table i get from email which further need to add in Excel to create tracker. but when i convert html data into plain text it removes all the spaces between the Raws and den i lost to find further steps to proceed on.
There is a get in touch form on my blog.