Unanswered

how to validate if a field has certain value in all collection Power Automate?

(0) Share

Report

Posted on by Community Power Pla...

Hi, I'm using microsoft dataverse to connect to my Dynamics 365 trial instance. and I'm using "List Rows" action. So I'm looking for a way for do something like value.all(new_status eq 20) then update related data...

Is there in Power Automate a expression or similar Like .net LINQ Collection.All(predicate)?

e.g.: List Result =

[

{"name":"foo1", "statuscode":100},

{"name":"foo2", "statuscode":2},

]

now how to validate if all retrieved records the statuscode is 100 in this example the result would be FALSE.

if I use foreach control I don't want to trigger the update action each time per record, just one for hole collection, thanks.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

PrasadAthalye on at

Like (0)

Report

You can use Array filter action.

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

Like (0)

Report

Hi, thanks.
but like the example above,
[
{"name":"foo1", "statuscode":100},
{"name":"foo2", "statuscode":2},
]

if i would like to know if all those results(in that example are 2... could be N ) the statuscode is 100, with filter it will just filter 1 record, doesn't it?(it wouldn't tell me if all records met certain condition).

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

Filter will give you output of array. You can check the length of an array which will let you know how many records met the condition.

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

Like (0)

Report

Ok got it, basically what I want to do is "if all retrieved records has an status 100" then update a table if not "do nothing"

should I use foreach control and validate one by one and setting a bool variable like and observer to handler that then validate that variable to continue with the flow.... is that the right way or I'm complicating things?
Thank you.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

Can you please clarify what do you mean "if all retrieved records has an status 100" ...

What do you mean status 100? Are you saying count of all retrieved records equals 100?

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

Like (0)

Report

Hi, yes I mean"if all retrieved records have an status 100" that collection query a column named statuscode so I need to validate if in that list returned all statuscodes have as value 100 here a representatio e.g.
[
{"name":"foo1", "statuscode":100},
{"name":"foo2", "statuscode":2},
]
wherever I placed the validation, it would be resolved as false because the returned data has an element with statuscode 2
[
{"name":"foo1", "statuscode":100},
{"name":"foo2", "statuscode":100},
] this result would be resolved as true beacuse all elements return have a status 100
thank you.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (1)

Report

I think you will have to use filter condition on list rows to filter all rows where statuscode eq 100. Then run a loop on that collection to fire an update.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

@Anonymous did you manage to solve this?

Was this reply helpful? Yes No