Get Flows in the last 15/30 mins

(0) Share

Report

Posted on by Gautham001

166

Hey all , i have a powerapp which updates or add rows into a SQL DB

I want to use a re-occurence flow which get's me the rows/items created or updated in only the last 15(or whatever timeframe) minutes.

The SQL DB has a column For time which records when the user submitted (or created) the record/row.

Currently i am trying this ,

I am using current time function to get the Time the flow is running at.

Ideally , i want rows/items which were created between The time Column in DB (example Submit Time) &Current Time

Any ideas to get created and updated rows in a certain timeframe would be appreciated.

Thank you.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
Hi @Gautham001

In the filter query, you're not doing an actual query. You need to provide a comparison so that I would do the following. Reduce 15 minutes from now and get all records that have a time greater than that:

columnName gt @{addMinutes(utcNow(),-15)}

Can you please check if and let me know if you have any questions?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Gautham001 166 on at

Like (0)

Report
Copy link

Link copied!

@manuelstgomes I have a similar query , but my struggle is

Since i am using Get Row's action and reoccurence is the trigger and i have no dynamic content to pick the field from. If i pass the columnname it does not work

Any suggestions on how to get the dynamic content to use in the filter query

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

HI @Gautham001

How do you filter the data? What's the pattern. Please note that the "column" name can be "dynamic," meaning that you can have a variable or something else with the column name. But you always have a target to filter.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Gautham001 166 on at

Like (0)

Report
Copy link

Link copied!

@manuelstgomes ,

I have 3 time columns. Which are time 1 , time 2 and user submit time(time at which user sends a request / row created in db time).

My constraint is simply ,
Time1 lt Submittime and Submittime lt time2 and Name ne null

I am trying to get records which have submittime in between the time1 & 2 and where the Name is not null

But again , the problem is when i try to search for the dynamic content i dont have it because of not using "when a row is created" trigger.

I have tried by just using the column name in the filter query , it is not working

How can i get this to work?

Was this reply helpful? Yes No
Gautham001 166 on at

Like (0)

Report
Copy link

Link copied!

@manuelstgomes or anybody , is there any way i can "get" the dynamic content here.

Was this reply helpful? Yes No