Adding multiple dates in an excel cell that prompt Power automated email reminders?

(0) Share

Report

Posted on by Brian-Cash

Hi all,

I have an excel file which I set up a scheduled cloud flow to email out reminders

(this is the exact flow: (3) Automate Emailing Excel Task Reminders with ZERO Coding! - YouTube)

Question is: I have a date field in the excel file which is the orgin and the dates pull corrcetly- is there a way I can add multiple dates in one cell so the flow will trigger on different dates

i.e Action Date would be

At present when I do it like this nothing fires! Only when I have one date.

Any help would be greatly appreciated

Kind Regards,

Brian

Categories:

Using flows

I have the same question (0)

All responses (15)

Answers (1)

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Brian-Cash

I do not see a trigger, or a flow picture of anything so its hard to help.

But it.. seems like you somehow want the trigger to read the Split(datesVlaues from excel, ;_ and use that array to schedule itself dynamically?

No you cannot do that, sorry 😞

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

BenUnlox 64 on at

Like (0)

Report

Hi @Brian,

This should be possible by using the ODATA Filter as in the screenshot attached. You'd first need to ensure that your Date column is formatted to be of a 'Text' type within Excel. Then add the following ODATA Filter to your 'List Rows...' action.

Expression: formatDateTime(utcNow(),'dd/MM/yyyy')
Filter Query: contains(ActionDate, <EXPRESSION>)

Does that work for you?

Thanks,
Ben

Excel-MultipleDat...

Was this reply helpful? Yes No
Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

He wants to literally trigger the entire flow, based on splitting that string, as if you can make a Trigger Condition with these values.

You cannot.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Brian-Cash 66 on at

Like (0)

Report

thanks for the replies @FLMike and @BenUnlox . Yes, the intention would be to list out multiple dates in the source excel and have the flow trigger if the dates matchs

Here is how the flow is currently mapped out:

Was this reply helpful? Yes No
BenUnlox 64 on at

Like (0)

Report

@Brian-Cash - Thanks! I believe my original suggestion will allow you to achieve what you're looking for here, with having multiple dates in a single cell.

Was this reply helpful? Yes No
Brian-Cash 66 on at

Like (0)

Report

Thanks for this. In List rows would this new exporession be in addition to the existing filter date or would it replace it? Thanks,
Brian

Was this reply helpful? Yes No
BenUnlox 64 on at

Like (0)

Report

@Brian-Cash - It would need to replace the existing filter condition. 😀

Was this reply helpful? Yes No
Brian-Cash 66 on at

Like (0)

Report

Ok, I have followed based on the screengrab though shoudl it not be in the ODATA/order by field?

Was this reply helpful? Yes No
BenUnlox 64 on at

Like (0)

Report

@Brian-Cash - Only if you want to specify how the items are ordered inside your For Each loop, otherwise it can be left blank.

Was this reply helpful? Yes No
Brian-Cash 66 on at

Like (0)

Report

Any ideas @BenUnlox ?
Thanks for the help so far- I'm quite new to all this in case you couldnt tell!

Was this reply helpful? Yes No