Answered

How to create a daily flow, and to process only if system date is equal to a date in an array

Like (0) Share

Report

Posted on 13 Jan 2023 04:10:01 by lxd

Hello. I am totally new to Power Automate. I was able to create a flow to run each day and email a file. I want to modify it such that it runs each day but does a compare to see if the run date is equal to any of the dates within an array value inside a compose function. I would hard code the dates into the array value. If the run date is in the array, then continue processing, else stop processing. This would repeat each day. I am not sure on how to set up the array of dates and in what format, and how to do the compare of the run date to see if it's equal to any of the dates in the array. Are there any examples on how to do this? Thanks for any help.

All responses (2)

Answers (2)

Verified answer

lxd 48 on 13 Jan 2023 at 21:54:43

Like (0)

Report

Re: How to create a daily flow, and to process only if system date is equal to a date in an array

@wearsky ,Thanks for the help. It works!. I would like to get it to work such that it can read the dates from an Excel file placed on Sharepoint or shared network. I assume this can be done. Don't know if I have to read the dates from Excel into an array first and then process, or if I just read the Excel file one row at a time. If there are any examples, that would be great. Thanks!
Verified answer

v-xiaochen-msft on 13 Jan 2023 at 05:44:00

Like (0)

Report

Re: How to create a daily flow, and to process only if system date is equal to a date in an array

Hi @lxd ,

Please try:

Best Regards,

Wearsky