Unanswered

Advice on new flow required

(0) Share

Report

Posted on by nocodecreative.io

Hi,

I'd like to build a flow that the outputs a table of columns each day, however I only want items in the table that match a few specific conditions.

So for example, I have status column, when the status changes to the value "not select", I want power automate to collect all the items in the last 24 hours that have changed to this status and add to a table, then the table is sent in an email each morning.

So I need a reoccurring schedule flow to start, then maybe get file properties, has column changed in a condition, would this work for a start, or does the trigger need to be "when an item is modified".

Either way, how would I get it to look back over the past 24 hours only? Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Pstork1 69,246 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you want to do it once a day then definitely use a recurrence trigger and a get file properties or get items. Try to filter it with an OData query, although you may not be able to get everything filtered out using just OData. Then use a Filter array to remove anything else that shouldn't be there. Use a Data select to specify the exact columns you want in the table and then convert the array to HTML. That can then be embedded in the email.

Was this reply helpful? Yes No
nocodecreative.io 61 on at

Like (0)

Report
Copy link

Link copied!

Thanks, what would the filter array need to look like to filter out anything that's hasn't been modified in the last 24 hours?

Was this reply helpful? Yes No
Pstork1 69,246 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
nocodecreative.io 61 on at

Like (0)

Report
Copy link

Link copied!

hi again - this query isnt working for me: @And(greater(item()?['Modified'],addHours(utcNow(),-24),less(item()?['Modified'],utcNow()))

Any idea why?

Was this reply helpful? Yes No
nocodecreative.io 61 on at

Like (0)

Report
Copy link

Link copied!

hi again - this query isnt working for me: @And(greater(item()?['Modified'],addHours(utcNow(),-24),less(item()?['Modified'],utcNow()))

Any idea why?

Was this reply helpful? Yes No
Pstork1 69,246 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The query is case sensitive. Its @and(.... not @And(....

Was this reply helpful? Yes No
nocodecreative.io 61 on at

Like (0)

Report
Copy link

Link copied!

yes I tried with lowercase - that's just my grammar correction on edge!!

Was this reply helpful? Yes No
Pstork1 69,246 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What error are you getting?

Was this reply helpful? Yes No
Pstork1 69,246 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Try the following. I think the one you are using might be missing a parentheses. This works for me.

@And(greater(item()?['Modified'], addHours(utcNow(), -24)),less(item()?['Modified'], utcNow()))

Was this reply helpful? Yes No