Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Get Items/Query Flow

(0) ShareShare
ReportReport
Posted on by 1,131

Hello,

I am new to Power Apps and am having trouble with the "Get Items" process.  At this point, I'm not sure if the "Get Items" is the best method for what I am trying to accomplish.

I have two lists 'EmployeeShort' and 'Assessment'.  When an individual enters a record in 'Assessment', I want a process to lookup their "Supervisor" from the 'EmployeeShort' list and update the "SupervisorLU" field in the 'Assessment' list.  At this point I am using Get Items in a Flow but am receiving the error shown.

RJF61_2-1655295391421.png

The item blacked out is an accurate value and is the result of the "Update Item" portion of the Flow (field is a 255 character text that is the DisplayName value of Created By) and is located in the 'Assessment' list.  The "FullName" field is located in the 'EmployeeShort' list multiple times.

 

The Flow I have created is below.

 

RJF61_5-1655295842196.png

RJF61_6-1655295941364.png

 

I assume my issue is related to the relationship for obtaining the Get Items  but need some assistance.  As shown above, the Flow currently fails at the Get Items Step.

 

Thanks for any assistance. 

 

  

 

 

Categories:
  • WarrenBelz Profile Picture
    148,743 Most Valuable Professional on at
    Re: Get Items/Query Flow

    Hi @RJF61 ,

    How is the first flow linked to the one you have posted (or a better question how and when is it run)? The data certainly needs to exist at the time the one in your post is run. I suspect the field is blank at the time.

     

  • RJF61 Profile Picture
    1,131 on at
    Re: Get Items/Query Flow

    Hello @WarrenBelz 

    So, again new to the Flow process, that is some of my concern.  The first Flow is updating CreatedByDN with the CreatedBy DisplayName when a new record is created.  Does the 2nd Flow need to run after the CreatedByDN is updated (otherwise no information would be available)?

  • WarrenBelz Profile Picture
    148,743 Most Valuable Professional on at
    Re: Get Items/Query Flow

    Hi @RJF61 ,

    You are getting Items from the list EmployeeShort where the field Fullname in this list (which we have established is a Text field) matches the output of the previous Flow in the field CreatedByDN. You have shown that the original field is also Text, but how are you outputting this from the other Flow - I would suspect that it coming out as something else.

  • RJF61 Profile Picture
    1,131 on at
    Re: Get Items/Query Flow

    RJF61_0-1655382087040.png

     

    RJF61_1-1655382157562.png

     

  • WarrenBelz Profile Picture
    148,743 Most Valuable Professional on at
    Re: Get Items/Query Flow

    Hi @RJF61 ,

    The first one is correct (enclosed in single quotes). It is also necessary that CreatedByDN is a string and (obviously) that FullName is also a string (have you looked at the Flow output to see what is returned?) The error appears to be that one is not a valid string.

  • RJF61 Profile Picture
    1,131 on at
    Re: Get Items/Query Flow

    Hello @WarrenBelz 

     

    Thanks for your response.  Following is the Advance Options portion.  I did use single quotes but it did not appear to make a difference if I entered FullName eq 'CreatedByDN' or FullName eq 'CreatedByDN.  Not sure if this is an issue; however, CreatedByDN is the result of a previous Flow.

     

    RJF61_0-1655379031490.png

     

  • WarrenBelz Profile Picture
    148,743 Most Valuable Professional on at
    Re: Get Items/Query Flow

    Hi @RJF61 ,
    You did not include the Advanced Options to show the actual filter, but you would normally need

    FullName eq 'Homer Simpson'

    Have you used single or double quotes ?

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1