Can we get all items from SharePoint list and filter the list using formula

(0) Share

Report

Posted on by johnjohnPter

1,837 Season of Giving Solutions 2025

I have a SharePoint online list which contains 2 columns; Title & PrincipleID . Both of type single line of text.

Now i want to get all the items from the list (which can be 15 on the PROD environment), then filter the items based on the Title column using formulas, and get the PrincipleID and pass it to different child flows inside our main flow.

Now i tried this test to get the PrincipleID of the Admin, but i got this error:-

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'first(equals(outputs('Get_items')?['body/value']?['Title']),'Admin')?['PrincipleID']' cannot be evaluated because property 'Title' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Any advice?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Expiscornovus 33,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Afaik you cannot use the equals directly in an expression like that. It would need a reference to a specific item of the 'value' list of items. However, in your case you want to filter to check all items and not a specific item. My suggestion would be to use an Filter Array instead.

Try and add a filter array action in between the Get Items and Compose.

first(body('Filter_array'))['PrincipleID']

Btw, you can also filter directly in the Get Items. But I assume you don't want that, because you mentioned in your opening post you wanted to retrieve all items first?

In that case the expression would be:

first(outputs('Get_items')?['body/value'])['PrincipleID']

Was this reply helpful? Yes No
johnjohnPter 1,837 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus

Thanks for the reply. But i do not want to only get the item with Title = Admin? i want to do this for all the others 15 items. and i do not want to end up having to define 15 separate FilterArray actions.. as this will force my flow to make additional Requests which i am trying to avoid.. that why i am asking how to get all items using single action (GetItems), then filter the items based on the title using formulas ... title can be 'Admin' in other cases it can be 'IT-Admin' , and so on..? Is this possible?

Was this reply helpful? Yes No
Expiscornovus 33,737 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Yes, you are right. Having so many Filter Array actions would be messy.

In my first reply I forgot about xpath, so we could use that. Apologies that I didn't think of that in my first reply 😅

Try the below in your Compose

join(xpath(xml(json(concat('{"root": { value:', outputs('Get_items')?['body/value'], '}}'))), '//value[Title="Admin"]/PrincipleID/text()'), '')

Was this reply helpful? Yes No
johnjohnPter 1,837 Season of Giving Solutions 2025 on at

Like (1)

Report
Copy link

Link copied!

Expiscornovus

Wonderful it worked well for me, this is exactly what i were looking for.

Thanks

Was this reply helpful? Yes No
johnjohnPter 1,837 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus

I am not sure why whenever i check "Does this answer your question?" checkbox, it got unchecked when i do a refresh .. but yuor reply is a valid answer..

Was this reply helpful? Yes No
Expiscornovus 33,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

That is strange, might be a new forum bug? I will see if I can reproduce this behaviour.

As long as my earlier reply helped you out, that is the most important thing 😁

Was this reply helpful? Yes No