cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lijo_Abraham
Frequent Visitor

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

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

7 REPLIES 7
Nogueira1306
Community Champion
Community Champion

Hey! Try this: 

 

Nogueira1306_0-1629711415117.png

 

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

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

Lijo_Abraham_0-1629788353654.png

Lijo_Abraham_1-1629788428477.png

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

 

Thanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,018)