Answered

Sending items when date is greater or equals to three weeks from today

(0) Share

Report

Posted on by HWib

103

Hello all, I am currently working on an agenda distribution in sharepoint. I would like to send out the list item in a table where the 'presentation request date' are between today to 21 days from today to the distribution list.

I got the table and e-mail part to work, but it sends all items. I am now stuck in the filter array part to filter these dates. help!!

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is exactly what I am trying to do but I am competely lost. Which flow do I start with? Can you please explain how you made it? Thanks!

Was this reply helpful? Yes No
HWib 103 on at

Like (0)

Report
Copy link

Link copied!

I followed the steps in the following post to create the HTML table.
https://powerusers.microsoft.com/t5/General-Flow-Discussion/Modify-Create-HTML-Output-for-formatting-purposes/td-p/125892

The flow looks like this. For Compose I have the following expression:
replace(body('Create_HTML_table'),'<table>','<table border="1">')

not sure how I should add the filter to send only those specific items with the presentation request date between those dates. Hope this helps to get you started.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, I think what you are trying to do is create create the html table based off a filter. I'll look into this as well and post back if I find the solution. Thanks for sharing!

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @HWib ,

You could first configure Filter query in Get items action to filter out the eligible items, and then configure the following action.

Image reference:

addDays(utcNow(),21,'yyyy-MM-dd')

Note that the expression needs to be enclosed in single quotes.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
HWib 103 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Barry.
I received this error message when using your suggestion:
{ "status": 400, "message": "The expression \"PresentationRequestDate'2019-03-13'\" is not valid.\r\nclientRequestId: 15de0362-c53c-4f6c-8307-7617c80a21cb\r\nserviceRequestId: 5bf5c19e-208c-7000-fec6-667bbec34875" }

This is how I inputted the query. PresentationRequestDate is the name of the field from which the query is being filterred:

Was this reply helpful? Yes No
HWib 103 on at

Like (0)

Report
Copy link

Link copied!

added ge in between the field name and the expression and flow was sent.
However, none of the data within the intended parameter (today up to 21 days from today) has been sent.

Here is the mock data that should have been sent:

Here is the e-mail received:

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @HWib ,

Please change ge to le.

Maybe I understand the conditions of your fault.

It seems that you want the Date of the Request Date to be less than or equal to today plus 21 days.

Please take a try again.

Edit:

If there is a space in the middle of the field name, replace the space with _x0020_ .

Like:

Presentation_x0020_Request_x0020_Date

Best Regards,

Was this reply helpful? Yes No
HWib 103 on at

Like (0)

Report
Copy link

Link copied!

Hi Barry,

Thanks for the feedback and suggestion.

The parameter would be Presentation Date is equal to or greater than today to less than or equal to 21days from today. I would need to have an 'And' operator in the expression, although I am not sure how to add that.

The agenda gets send out, but now it includes dates that are in the past.

Here is the screenshot from the Flow:

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @HWib ,

Try using the formula below:

addDays(utcNow(),30,'yyyy-MM-dd')

utcNow('yyyy-MM-dd')

Best Regards,

Was this reply helpful? Yes No
HWib 103 on at

Like (0)

Report
Copy link

Link copied!

great it works!!! thanks, Barry!

Was this reply helpful? Yes No