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.

Categories:

Building flows

All responses (2)

Answers (0)

Sort by

grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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')
RustyFuture100 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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