Unanswered

I need to run flow for 12 month (year)

(0) Share

Report

Posted on by Community Power Pla...

Hello team. I have created a flow and it is working properly. but the issue is that each 30 days I have to re-run it again. and my question is it possible to run a flow for more than 30 days

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report

Hello @Anonymous
Could you provide more information about the flow? Is this an approval flow that is timed-out? Could you share a screenshot so we can help you?
Regards,
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for response here is a screenshot:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hello @Anonymous
As I understand, is the delay action greater than 30 days then? What is the idea of your flow? Probably it can be done in another way...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Helo @fchopo ,

the propose of the flow is to send reminder email to a particular person based on a column "date" in excel table file. in other words:

When date is XXX send reminder to person 1
when date is YYY send reminder email to person 2
when date is YYY send reminder email to person 3
…...etc

Appreciate you help 🙂
….

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @Anonymous ,

Why are you add the delay in the flow? you don't mention it in the last reply.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-alzhan-msft,

I did not find something else to replace the Delay unit.

What I want is to build a flow to send email reminder for particular person based on a date from Excel Table:

Example:
When date is XXX send email to person 1
when date is ZZZ send email to person 2
When date is YYY send email to person 3

the email should trigger based on the date

the current setup is working perfectly for 30 days only. after that I need to re-run the flow. is there anything I can use or change to make the flow more than 30 days.

Thank you

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hello @Anonymous
If I have understand what you want, you could create a scheduled flow to run daily, and check if the date equals the date column in excel. Have a look at this thread: https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-look-at-Excel-file-and-send-email-if-date-matches-todays/td-p/200202

Hope it helps
Ferran

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @Anonymous ,

What is XXX,YYY,ZZZ that you mentioned?

You still don't explain it well.

You should explain what is the relationship between the date in excel and the date XXX,YYY,ZZZ, does the XXX,YYY,ZZZ is the future of the date in the excel? such as the XXX would be 2 month later than the date in excel?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @fchopo ,

Thank you for response and suggestion.

I have used the filter Array with following:

@equals(formatDateTime(item('Apply_to_each')?['Time'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))
but in this case the flow sends email to all list even if the today's date (UTCnow) does not match the date in excel table, column (Time).

Was this reply helpful? Yes No