Unanswered

[Get-Items - Filter by nested property not working]

(0) Share

Report

Posted on by SWO-Sujithkumar

I would like to query my SharePoint list using Get-items action on PowerAutomate. I wanted to use filter in the action like this [AgreementStatus/Value eq "SentforSigning"] but this query is not returning the results instead errors out "invalid query syntax".

"body" :{
 "value":[
 {
"AgreementStatus" :{
 "@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id":1,
 "Value":"SentforSigning"
 },

 }
]

I referred to the following articles to format the query but yet no luck.

Odata Filters & nested objects with Microsoft Flow - Power Platform Community

OData - filter by nested property - Stack Overflow

Please assist.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
@SWO-Sujithkumar Get items filter query syntax left side must have SP list column internal name ( exception for People field). In your case it should be

AgreementStatus eq 'SentforSigning'

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
SWO-Sujithkumar 19 on at

Like (0)

Report

It worked Great Thanks

Was this reply helpful? Yes No