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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Answered

Problem

(0) ShareShare
ReportReport
Posted on by 17

Hi,

 

Can you give me the code of value in expresion if i have 2 filter query in get items. thanks for answer

112233

Categories:
I have the same question (0)
  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @DzakyS 

    What is the datatype of the department columns?

    Can you share a full screenshot of your flow?

     

  • CU-18081211-6 Profile Picture
    9,270 Moderator on at

    @DzakyS ,

    The ODATA query looks fine.... Remove the parenthesis and everything is fine.

    Is Department a lookup/choice column ? 

    In approvers action (initalize/set array variable) do you use references to previous action (get items actions name )? Like:

     

    outputs('PreviousAction')['body/value']

     

    Because I didn't see it in your formula. 

     

  • DzakyS Profile Picture
    17 on at

    Hi @Mira_Ghaly 

     

    for your question :

    1. my datatype of the department coulumn is "single line of text"

    2. here my flow it still new flow because i watch in mr.Reza video in youtube also i still learning about power automate becasue its my first job eventhough different with my major

     

    4.png5.png6.png

  • DzakyS Profile Picture
    17 on at

    hi @gabibalaban 

     

    thanks for reply my post, you can see my full flow i already post in reply in @Mira_Ghaly 

  • Verified answer
    CU-18081211-6 Profile Picture
    9,270 Moderator on at

    In Approvers action use: 

    outputs('Get_Approvers')['body/value']

    This will give put in an array variable the outputs of the Get Approvers action.

  • DzakyS Profile Picture
    17 on at

    thanks for answer @gabibalaban but can i ask again ?

    1. why in the reza video they use '0' in outputs?

    2. and why in the reza video they have 'claim' in action select. but when i find my flow i cannot find it.

    this is the link video i watch Power Automate Multi Level Approval Workflow | Serial Approval | Multiple Approvers - YouTube the minute in 15.00 and what the function action of 'select' 

    thanks for answer

    7.png8.png9.png

  • Community Power Platform Member Profile Picture
    on at

    @DzakyS hello, did you find a solution for this? I'm stuck at the same step.

    @gabibalaban we would really appreciate your help. 🙂 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard