Unanswered

OData Filter syntax help

(0) Share

Report

Posted on by RustyFuture100

Hi All,

New Power automate user here and would value some input from you. I have a flow that gets the response from a MS form. I then want to filter an excel spreadsheet to return one value based on a response to the column called DMS in the form. I'm using the list rows in a table excel connector to connect to a sharepoint file. My current filter syntax looks like @And(equals(item()?['TopSite'], outputs('Get_response_details')),equals(item()?['SubSite'],''))

What time trying to achieve in Pseudo code is TopSite = DMS(Form response) and SubSite is null to filter the returned rows down to a single value. any help would be greatly appreciated.

I have the same question (0)

All responses (2)

Answers (0)

grantjenkins 11,059 Moderator on at

Like (0)

Report
Re: OData Filter syntax help

You have the following in your condition which should have your actual field from the Form listed also. At the moment you are comparing TopSite with the entire response.

outputs('Get_response_details')

Was this reply helpful? Yes No
RustyFuture100 2 on at

Like (0)

Report

Re: OData Filter syntax help

Hi Grant,

thanks for your response.

i'm get an error when I change the filter syntax and I'm unable to see the form responses from the filer (they are not appearing in the dynamic data options)

although i can see them from a condition branch father downstream of the filter

Was this reply helpful? Yes No