You’re offline. This is a read only version of the page.
I'm trying to make an approval workflow which is triggered when a form is submitted. When a response is submitted, a new Sharepoint item is created in an approvals list. I then want to get items from a, Approvers list, which contains the approvers, for a given type of request which is in the title column. I'm using the filter query step, trying to filter for where the request type in the form is equal to the Title column in the Approvers list. I'm not getting any output from filter query, when using statement '@equals(item()?['Title'], triggerBody()?['RequestType']?['Value'])'.
Screenshots of flow here:
To test, create two Compose actions. In the first Compose action put the Form Response dynamic content. In the second Compose step put the Title dynamic content of the Get Items (It will automatically go into an apply to each).
Run a test flow and see what the outputs of the two Compose steps look like. You might be able to see a difference in the outputs.
-------------------------------------------------------
A second thing to think about is putting the filter directly into the Get Items so that you don't need the extra step of the Filter Array. In the Get Items action go to the Filter Query field and enter
Title eq ''
Between the two single quotes put your dynamic content form response.
Get Items Filter Query
First you need to make sure the responses will match by testing the compose outputs. You need to make sure they are matching or else you will just move your problem up to the Get Items action.
Let me know how it works out
Share
Report
All responses (
Answers (
6,519
