Filtering data in power automate

(0) Share

Report

Posted on by SARAHBEAHAN

Hello,

I have created a new flow by setting a reminder, to remind me 540 days in advance of the 'Review Date' in my list.

I am trying to work out how I can limit the captured data to only active list items in the 'Contract Status' column as well as a particular contract type on the 'Contract Type' column.

Below is a screenshot of my existing flow however, it is currently capturing all data in my list (i.e. a;; contract types and as well as active and ceased contracts).

Many thanks

Sarah.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@SARAHBEAHAN ,

What is in your Filter query?

oData filter can only filter Text columns.

You could use the Filter action to filter out your records

Output from your GetItems can be fed to the action below:

Was this reply helpful? Yes No
SARAHBEAHAN 30 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Thank you for your response.

My current filter query is;
concat(concat('field_17',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('field_17',' lt ','''', outputs('x_Days_+_1'),''''))

Where abouts in my flow should I add the Filter Array action?

Many thanks
Sarah

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No