Skip to main content

Notifications

Power Automate - General Discussion
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

  • Re: Problem

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

    @gabibalaban we would really appreciate your help. 🙂 

  • DzakyS Profile Picture
    DzakyS 17 on at
    Re: Problem

    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

  • Verified answer
    CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 on at
    Re: Problem

    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
    DzakyS 17 on at
    Re: Problem

    hi @gabibalaban 

     

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

  • DzakyS Profile Picture
    DzakyS 17 on at
    Re: Problem

    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

  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 on at
    Re: Problem

    @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. 

     

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: Problem

    @DzakyS 

    What is the datatype of the department columns?

    Can you share a full screenshot of your flow?

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard