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
Unanswered

Get Items Failing

(0) ShareShare
ReportReport
Posted on by 92

I'm building a flow that I have done in the past but It is failing with a weird message

 

I have 2 ShairPoint Lists ...

  1. List of Sites/Branch marcgiag_0-1671634785150.png
  2. List of camera at each Site/Branch marcgiag_1-1671634809994.png

     

  • I am running a Get Items on List of Sites/Branch (no problem)
  • I am running a Second Get Items On List of camera at each Site Branch and it is failing because it states:

"Column 'AUB' does not exist. It may have been deleted by another user."  The weird thing to me is AUB is not one of my Columns its data with in the columns

marcgiag_2-1671635110549.png

Below is how the 2 Get Items are set up any help would be appreciated 

 

 

Categories:
I have the same question (0)
  • OliverR-82 Profile Picture
    619 on at
    Re: Get Items Failing

    Hi @marcgiag 

     

    Can you include a screenshot of the 2 'Get items' actions? You refer to them in your post but they're not showing up (at least not for me).

  • marcgiag Profile Picture
    92 on at
    Re: Get Items Failing

    marcgiag_0-1671636662152.png

    Oliver I'm sorry about that that was actually my fault 

  • OliverR-82 Profile Picture
    619 on at
    Re: Get Items Failing

    In the 'Get items 2' action, you should enclose your filter value in single quotes. So, the 'Branch' dynamic value should be enclosed in single quotes. Could you try that and see what you get?

  • marcgiag Profile Picture
    92 on at
    Re: Get Items Failing

    @OliverR-82 same issue 

    marcgiag_0-1671638808241.png

    'Title' eq @{items('Apply_to_each')?['field_0']}

     

    Column 'AUB' does not exist. It may have been deleted by another user.
    clientRequestId: 1c827332-69d3-45d3-b7de-20f3730e381d
    serviceRequestId: 1c827332-69d3-45d3-b7de-20f3730e381d

     

     

  • Verified answer
    Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on at
    Re: Get Items Failing

    Hi @marcgiag,

     

    could you try like it.

     

    Amit_Sharma_0-1671641013946.png

     

     

  • marcgiag Profile Picture
    92 on at
    Re: Get Items Failing

    That looks like it worked... thank you so much 

  • OliverR-82 Profile Picture
    619 on at
    Re: Get Items Failing

    Lol, that's exactly what I said 🙂 I literally said put the 'Branch' dynamic value in single quotes.

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard