Answered

Create HTML table and send email

(0) Share

Report

Posted on by lwy

I have a very simple flow to extract a list of stores due for contract renewal in 180 days.

However, I have 2 issues:
1. At first the flow worked but the list of extracted stores was incorrect. The date was not within 180 days of expiry.

2. idk why but today, the HTML table does not extract any stores anymore...

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @lwy
Thank you for posting.
I have made a test on my side and it works fine for me.
You can take a try with the expression in Filter Query instead of set variable:
LeaseEndDate le '@{addDays(utcNow(),180,'yyyy-MM-dd')}'
This is my test list
After flow runs, I will receive the email
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Tumelo1 10 on at

Like (0)

Report
Copy link

Link copied!

am getting this error trying to follow your steps

The expression "Policy Expiry Date 'True'" is not valid. Creating query failed.
clientRequestId:
serviceRequestId:

Was this reply helpful? Yes No