PowerAutomate Working with Dates

[almendoza26]

I could't find that is closely related to my issue.

Anyway, I have a date column in a Document library named "Valid date". I wanted to send an email to the owner of the document 6 weeks, 2 weeks and 1 day before the valid date.

Here's my condition in Flow:

[v-bacao-msft]

Hi @almendoza26 ,

It seems that the screenshot is missing, please try uploading again.

Best Regards,

[v-bacao-msft]

Hi @almendoza26 ,

You could try the following expression:

Best Regards,

[almendoza26]

Hi Barry,

I don't know if I explained it clearly.

I want to check if the valid date is 36 days to 42 days away from today. This is for 6 weeks and here's my expression for 6 weeks:

[v-bacao-msft]

Hi @almendoza26 ,

Please try the following configuration:

Best Regards,

[almendoza26]

@v-bacao-msft 

I tried what you suggested, however the flow failed with this error:

[v-bacao-msft]

Hi @almendoza26 ,

Could you share the expression you are using and the screenshot of the configuration?

Best Regards,

[almendoza26]

@v-bacao-msft 

Here's the expression:

[v-bacao-msft]

Hi @almendoza26 ,

I'm afraid I can't see any errors. Anyway, I observed that the format of the date output by Valid Until is yyyy-MM-dd. You can directly configure the Dynamic Content of Valid Until or the output of Compose in the parameter on the left of Condition.

Best Regards,