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...

All responses (2)

Answers (1)

Tumelo1 10 on at

Like (0)

Report

Re: Create HTML table and send email

am getting this error trying to follow your steps

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

v-LilyW-msft on at

Like (0)

Report

Re: Create HTML table and send email

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.