web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Dynamic Forms Approval Workflow - Issue with Filter Arrray

(0) ShareShare
ReportReport
Posted on by

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.pngScreenshot 2023-06-29 101015.pngScreenshot 2023-06-29 101111.png

I have the same question (0)
  • wskinnermctc Profile Picture
    6,519 Moderator on at
    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 QueryGet 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard