Hi this is sivaji , I need help to create flow Scenario: Read data from db2 database and export those data to excel and in that excel last column mail is there so we need to send each person mail with their data with those excel export in power automate can you please help me on this quickly
Hi, I have a scenario like can you please help me I will be receiving emails from specific people with a specific table in the body of the email. I wanted power automate to copy those tables and paste it in a Excel sheet Can you please help 😊
Hi Have a look at this blog. tomriha.com/parse-data-from-an-html-table-in-an-email-with-power-automate/ Also there are few videos out there regarding the same subject. ruclips.net/video/i4GHCGMAD88/видео.html Thanks
Hi this is sivaji , I need help to create flow Scenario: Read data from db2 database and export those data to excel and in that excel last column mail is there so we need to send each person mail with their data with those excel export in power automate can you please help me on this quickly
Hi You need to get the emails first from the excel. For this you need to use union() expression to get all the unique emails after reading the Excel sheet using List Rows. Next iterate the results of the union so that you get each email and use the Filter action step or List Rows with filter query matching each email. Next you can use this result to use the Select actions step to select the values which you want to email. Finally map the results from the select action step in your email. Thanks
Hi this is sivaji , I need help to create flow
Scenario:
Read data from db2 database and export those data to excel and in that excel last column mail is there so we need to send each person mail with their data with those excel export in power automate can you please help me on this quickly
I have already replied this in your other post.
I'm trying to do the same action but when I change the expression with "_name" I can't... I received this message: "The expression is invalid."
Hi, I have a scenario like can you please help me
I will be receiving emails from specific people with a specific table in the body of the email. I wanted power automate to copy those tables and paste it in a Excel sheet
Can you please help 😊
Hi
Have a look at this blog.
tomriha.com/parse-data-from-an-html-table-in-an-email-with-power-automate/
Also there are few videos out there regarding the same subject.
ruclips.net/video/i4GHCGMAD88/видео.html
Thanks
Hi this is sivaji , I need help to create flow
Scenario:
Read data from db2 database and export those data to excel and in that excel last column mail is there so we need to send each person mail with their data with those excel export in power automate can you please help me on this quickly
Hi
You need to get the emails first from the excel. For this you need to use union() expression to get all the unique emails after reading the Excel sheet using List Rows. Next iterate the results of the union so that you get each email and use the Filter action step or List Rows with filter query matching each email. Next you can use this result to use the Select actions step to select the values which you want to email. Finally map the results from the select action step in your email.
Thanks