Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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



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."

Community Champion
Community Champion

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

Solution Sage
Solution Sage

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

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 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?



Frequent Visitor

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.

Solution Sage
Solution Sage

 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

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'



Helpful resources

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,296)