How to send multiple list items in ONE email using Microsoft Flow with an IF condition

[Lijo_Abraham]

Hi,

I am trying to design a scheduled flow wherein I get reminder email for an activity or set of activities that has already been due or about to be due as per my Planned dates.

Could you please hep with the best possible method?

I also tried to use the ODATA filter query to compare the Planned date with the reminder date(calculated value) to get a consolidated list but it came up with an error "The field 'Reminder_x0020_Date' of type 'Calculated' cannot be used in the query filter expression."

[Nogueira1306]

Hey! Try this: 

Get itens and filter if Reminder date is equal to today

After that, create an HTML table with that items

Insert the outputs in a compose

Insert the compose output inthe email you want to send

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

[eric-cheng]

Hi @Lijo_Abraham ,

You can upvote the idea to enable calc fields in odata here.

You can look at filtering the array here

but it will be slower or modifying your formula here

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Lijo_Abraham]

Thanks for your reply... How were you be able to add multiple conditions under "Get Items Filter query"? Because when I see the the window it is just a single text box, also the expressions that you have used is not visible completely. Could you please elaborate your solution a bit further as for me being new to Power Automate it becomes a little complex.

Thanks

[Lijo_Abraham]

Thanks for your response.

The filter array looks promising but how can we just keep the date and not the time.

If I need to keep getting reminders for more number of days then should I be using more number of Filter arrays?

Thanks

[Lijo_Abraham]

I did some research and combined few inputs to get the following result where I only use the dynamic content and still able to filter the due dates as per the actual planned dates, combine all the output vales and send 1 email as the notification.

Do let me know if this looks like a good solution as well:

So with this I will not need a calculated column for date as date & time function will compare it with the actual planned date and accordingly give me reminders for past due activity or the ones which will be due in the future.

Please do let me know if this can be a viable solution.

[eric-cheng]

 Hi @Lijo_Abraham ,

Did you want to have two emails or a single email?

In your Get Items odata query, you can use Col eq 'past date' or Col eq 'future date'

This will give you a consolidated list

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Lijo_Abraham]

I want to have single email for all overdue activities and another email with all due activities.

What did you mean by "Col eq 'past date", as I didn't find any condition as 'past date'

Thanks.