Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Get item failing
Power Automate - Building Flows
Answered

Get item failing

(0) ShareShare
ReportReport
Posted on by Chicko29 38

I am trying to capture a single record from a SharePoint List using flow. I am using the get items, select, apply to each actions to accomplish that. The get item action is not running successfully. I get the following error. Yet, column XYZ does exist in the SharePoint List.

 

Column 'XYZ' does not exist. It may have been deleted by another user.
clientRequestId: 1d5f3d1a-0100-406e-92f1-a1ffcb020c7f
serviceRequestId: e085a19e-1000-7000-2923-88290d38c03b 

 

I don't know what I'm missing because the column does indeed exist. To filter out the data, in the filter query option, I put: XYZ eq 'variable'. The variable comes from PowerApps.

 

  • Chicko29 Profile Picture
    Chicko29 38 on at
    Re: Get item failing

    The issue was the column name. I had to check the column name in Powerapps to see that it was different than what is displayed in the SharePoint List. It works now. Thank you!

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Get item failing

    Hi @Chicko29,

     

    Could you share a screenshot of the flow?

    Do you get the error on step Get items?

    I have made the following flow, action Get items works properly. Besides, when using the Select action, please make sure each field under the specified column has a value.

    1.PNG

    Please share more details to help reproduce this issue.

     

    Best regards,

    Mabel

  • Verified answer
    PieterVeenstra Profile Picture
    PieterVeenstra 2 on at
    Re: Get item failing

    HI @Chicko29,

     

    Is XYZ the internal name of the column?

     

    Please go to the list settings and find the column in the settings. Click on the link and check in the url the internalname for the field. Does trhis macth with the column name that you are using?

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

News and Announcements

Welcome to the Power Platform Communities

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 Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans