Unanswered

Using Power Automate to create HTML table from excel

(0) Share

Report

Posted on by MohamedMohamed

Hello!

I'm trying to use Power Automate to send an email that contains an HTML table from an Excel file based on the due date and today's date. this success to send emails for all of them together in repeated emails, but I need one email with overdue actions.

Please, can anyone help me? Thanks,

Here is the flow:

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (0)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@MohamedMohamed You can try to Filter the based on condition, see section "Date Column Is Greater Than Or Less Than" For details see - https://www.matthewdevaney.com/how-to-filter-excel-table-rows-in-power-automate-text-numbers-dates/#Date-Column-Is-Equal-To and then send an email with only the overdue records.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
MohamedMohamed 10 on at

Like (0)

Report

Thanks @CFernandes
I did the steps in the link but I got errors as below in compose. Thanks in advance for your support.
First the error during saving step:
then details steps:
1- List of rows:

2- Select:
3- Compose

4-comopse 1
5- Filter Array (item)
6- Filter Array (Output)

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @MohamedMohamed

Apologies for not getting back earlier... Did you mange to resolve the problem? I see that you are using "List rows in the table". In that case, you can directly set the date to ISO format and then try to compare the values.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
MohamedMohamed 10 on at

Like (0)

Report

Thanks @CFernandes, never mind!
Unfortunately, I could not find a solution for my problem.
May I explain it more and appreciate your support.
the problem is I have Excel table with actions. Each action belongs specific responsible person. So, I have several actions with different responsible persons. Also, each action has due date.
Once the due date overdue becomes late, then I want to send an email with all late actions in one table to specific responsible person. So, I believe this requires two filters one for the late action and second for responsible person.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @MohamedMohamed

You can create a Recurrence Flow that checks the Duedate and compares with Today... If you use Equals 'eq' you can directly use the Filter query..

formatDateTime(utcNow(), 'yyyy-MM-dd')

Sample Power Automate below...

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
MohamedMohamed 10 on at

Like (0)

Report

Thanks, @CFernandes for your support; unfortunately, I couldn't reach the solution, so I used the filter function in Excel, then I used Power Automate to send the emails only.

Thanks again for your kind support!

Was this reply helpful? Yes No