Unanswered

Only send mail if item was created within the last time the Flow was run

(0) Share

Report

Posted on by cbernier35

Hi, I have a Flow created that runs on a schedule that pulls objects from Microsoft Graph and sends a mail to an admin on newly created objects. The Flow runs every hour and on the next run I only want to send mail about object created within the hour after the Flow ran last time. Is there a creative way to do this?

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can store the date and time using the convert time action. And passing in utcNow()

Now you will need to store this date time somewhere. Anywhere that the flow can access. Like SharePoint, Or SQL.

At runtime you can query and get the date time value and use that as a filter on the Graph objects.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
cbernier35 50 on at

Like (0)

Report
Copy link

Link copied!

How would you filter the Graph items? Would you Parse the JSON and then do a select or would you filter the query during the Graph call? Any examples you can share?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hi @cbernier35,

did you read this: https://docs.microsoft.com/en-us/graph/query-parameters ?

Was this reply helpful? Yes No
cbernier35 50 on at

Like (0)

Report
Copy link

Link copied!

Yes, many times. You can't do dynamic calls using $filter such as utcNOW()

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

But the value of utcNow() you can add to the search parameter, correct?
Did you do that?

Was this reply helpful? Yes No
cbernier35 50 on at

Like (0)

Report
Copy link

Link copied!

no that doesn't work for Graph calls. Ideally I need utcNOW() -x number of minutes From what I can tell you can't do that in a Graph call. Only specific date/time value is allowed.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Sorry I don't understand what's your problem.
1. define a string value currentDateTime
2. set currentDateTime=formatDateTime(utcNow()-x, 'MM/dd hh:mm')
3. create URL for the graph request using currentDateTime
etc

Was this reply helpful? Yes No
cbernier35 50 on at

Like (0)

Report
Copy link

Link copied!

Sorry should have been clearer. I have no option to do in the Graph query directly without creating a variable first. I'm using Postman to create the auth and query then importing as a custom connector in Power Automate.

I want to do this: https://graph.microsoft.com/v1.0/xyx/?$filter=xyzDateTime gt (utcNow()-x, 'MM/dd hh:mm')

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Use premium action 'Invoke an HTTP request' instead of the custom connector.

Was this reply helpful? Yes No