How to create remainders in MS Flow?

(0) Share

Report

Posted on by SpDev

Hi,

I have a Flow that listen for new items added to a list and pick the data of this item and copy them to a second list.

Well, when this new item has been in the second list for ten minutes without been opened or readed I need that Flow send a remainder to a specific user so he nows that there is a new item in the second list.

I have tried to apply this steps: https://medium.com/@thomasgranheim/send-reminder-emails-using-microsoft-flow-and-office-365-606e0ea1565b but is not working.

I made this change to the sample:

Instead of using days I am using minutes:

addMinutes(utcNow(),10,'yyy-MM-dd07:00:00Z')

the idea here is wait 10 minutes before the flow goes to the next step which is get the column that contains the date and filter it using: Filter query: ColumName eq datetime "Output":

But when I run the flow I get this error:

The "anmalningsdatum"-column is of type Date without time.

The entire O365 and SahrePoint are in swedish timezone

What I am doing wrong?

Best regards

Americo

All responses (12)

Answers (0)

feildennisvf 2 on at

Like (0)

Report

Re: How to create remainders in MS Flow?

I appreciate you bringing this matter to our attention. I can relate to experiencing a similar situation recently.

Your sharing is much appreciated.

Smart Health Pulse
hiralsharma 2 on at

Like (0)

Report

Re: How to create remainders in MS Flow?

How does MS Flow make remainders? Thank you for sharing your knowledge.

Best regards

Hiral Sharma
brouglubinez 2 on at

Like (0)

Report

Re: How to create remainders in MS Flow?

Thank you for sharing this issue with us. I also faced the same thing a few days ago. Thank you very much. InfoMaster
soniakhank 2 on at

Like (0)

Report

Re: How to create remainders in MS Flow?

This is really great and useful information. I'm glad you shared this useful information. https://www.hyderabadescortstars.com
Community Power Pla... on at

Like (0)

Report

Re: How to create remainders in MS Flow?

I truly like and value your work. I truly like your style. You rock and please keep up the successful work
Visit my Website : http://natasharoy.in
rvacchi 2 on at

Like (0)

Report

Re: How to create remainders in MS Flow?

hello americo

hope you are well i am trying to do the same thing..did you find a solution for it?

I look forward to..

Many thanks
SpDev 33 on at

Like (0)

Report
Re: How to create remainders in MS Flow?

Well, I was testing the workaround for a couple of hours and it didn't worked.

So I am back to the original flow and I checked which format the dates has.
The column date is in this format:
2018-09-24T22:00:00Z

and the output of the compose step is like this
2018-09-25T21:24:59Z

the problem is in the filter query. When I use it like this:
Cloumn eq datetime'output'
i get this error:

I get nothing. Is like if the flow can't find any item matching the query filter.

Regards
Americo
SpDev 33 on at

Like (0)

Report
Re: How to create remainders in MS Flow?

Right!
I have found a workaround that it seems to work.
Instead of using a filter query like this:
addMinutes(utcNow(),10,'yyy-MM-dd07:00:00Z')
I am using "Get future time" and then filter the list items by this future time. And its work almost perfect.
The only problem is that if I have 2 or more items in the list I am getting just one email. It seems like as soon the flow find the first item in the list, send an email and skip the other items.

I haven't made any change in the "Apply to each" section, so I don't know why is skipping the other items.

Regrads
Americo
SpDev 33 on at

Like (0)

Report

Re: How to create remainders in MS Flow?

Thanks Alice!

I have created a brand new list with just two columns, one of them of type date with time and I recreated the flow following your instructions but I still getting the same error 😞
v-yuazh-msft on at

Like (0)

Report

Re: How to create remainders in MS Flow?

Hi @SpDev,

If your "anmalningsdatum"column is of type Date without time, the value of "anmalningsdatum"column would be with type "yyyy-MM-dd", so it is not possible to filter out any items if your compare the "yyyy-MM-dd" with "yyyy-MM-ddTHH:mm:ssZ".

Please take a try to modify the "anmalningsdatum"column is of type Date with time.

Also please take care of the expression in the Filter Array field:

You should add a ' 'out of the Output dynamic content instead of " ".

Best regards,

Alice