Hi,
i am trying to create a flow.
which should send out email to users one every 6 months (interval) until a specific date.
the flow should get the data from a excel sheet.excel table
any one has ever made something similar to this
thanks

Hi,
i am trying to create a flow.
which should send out email to users one every 6 months (interval) until a specific date.
the flow should get the data from a excel sheet.excel table
any one has ever made something similar to this
thanks
First you need a scheduled trigger for every six months.
To check a specific date you need the below
Above the expression I used is formatDateTime(utcNow(),'yyyy-MM-dd')
Next we need to add Yes and No condition. If the date is reached the specified date we can terminate the flow. If not add the excel connector and access the rows. See below