Dynamic Forms Approval Workflow - Issue with Filter Arrray

(0) Share

Report

Posted on by brendan3

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: Screenshot 2023-06-29 100931.png Screenshot 2023-06-29 101015.png Screenshot 2023-06-29 101111.png

I have the same question (0)

All responses (1)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

Re: Dynamic Forms Approval Workflow - Issue with Filter Arrray

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

Was this reply helpful? Yes No