Send email on specific date

[Burkavic]

Hi,

I am trying to create an automatic email to be sent out on a specific date. I have managed to get the email that i want to be sent out but instead of the date i require it is sending it out every day. I would like to send the email out on the 'Date of reminder'. Any help would be appreciated.

[Andrew_J]

@Burkavic 

You have given me some learning on this one.  I think your flow needs simplification but I could have missunderstood your requirements.  My flow is below:

It takes data from the excel table like yours, it then gets the table, then list the rows.  It this I filter as below:

Column2 is date, which I set several with todays date of 17/04/2024 (UK).  The expression is:

formatdatetime(utcnow(), 'dd/MM/yyyy')

This provided the following basic array with column1 being an email field:

This then with the apply to each, sent a seperate email out to each of the items returned from the filter action.

I have since ammend the flow to add the recurance that you have used as the trigger.

Hopefully the above helps in some way.

Regards,

Andrew

[Burkavic]

Hi Andrew,

Firstly I am quite new to using Power Automate so apologies if I am being stupid. I think my issue lies with the 'Filter array'. I see you use the filter query, I was having issues with this so i used the filter array instead. I copied your time format so that it would just extract todays date from the table but still everyone is getting an email everyday and not on the date of reminder.

Many thanks for your input!

[Andrew_J]

@Burkavic 

Have you tried actual filtering in the excel app as per the below:

Your data

My data

Then add a compose after this step and see what you get from the body of the above step or just look at the RAW output.  Which is what the following is.

Most of the experts suggest this method and I tend to use it myself now, it takes a little time but you do get there in the end.  When I was looking at this yesterday I found an issue that way.

I tend to use my throw away email address for a lot of my testing only transfering to real users when it is 95% there and I need some real world responce.

Perhaps starting again with the Flow would help. 

Andrew

[Burkavic]

Hi Andrew,

When i try to use the filter query as you did i get the following issue;

Invalid filter clause: cannot find the 'Dateofreminder' column. clientRequestId: b00d9427-ad56-466e-9e0a-5429c331b5a3 serviceRequestId: fe922fd0-eb8a-4f1e-8ae1-ef79e21e1a4d;297eea61-aa0d-4433-85bd-52ed3d4e7311;686cd422-841e-476d-9cf5-f5e8c5cfe341

This was the reason i used the work around of the filter array. I do not know why is doesnt find the column for the 'Date of reminder' 

[Andrew_J]

@Burkavic 

Sorry but I think we are very near.

Your Excel columns has spaces in the description but your filter does not, both need to match.  You could use 'Date_of_reminder' in both locations which would then work.  But the only issue is the Excel file and this colunm name looking different.  If you needed the columns to look as they are at the moment then you could add another column with the title formated as 'Date_of_reminder' and then hide this so other users do not see it.  This is only typical if you use the filter in the List Rows as you have above.

If you wanted to use the 'Date of reminder' as you have now then use the standard Filter and that will wokr with the spaces in.

Regards,

Andrew