Answered

Get items action returning errors

(0) Share

Report

Posted on by Gilmour1

I have this very simple flow, where I want to get items from SP list 'B' where the value in field 'Code B' matches the value on field 'Code A' in SP list 'A'.

Action Get items 1 gives error:

Action 'Get_items_1' failed: Column 'S00929' does not exist. It may have been deleted by another user. clientRequestId: 404aa262-a7d9-457c-8619-d6dbb65d0163 serviceRequestId: 84029aa1-c0ee-c000-a096-58f28650287f

I've checked and value S00929 is present both in SP list A and SP list B, and it's the first item in the output of Get items (so action Get items 1 fails immediately). Any idea what the issue may be due to?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

rzaneti 4,481 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Gilmour1,

In this case, the error message is saying that a column named S00929 is not found in the List B. I recommend you to double check if you are passing this value in the right place on your filter query: assuming that you are checking value in A equals to value in B, it would be something like CodeB eq 'S00929'.

Also, feel free to share an image of your inputs to the filter query, so we can try to find any potential issues there.

For those users that find this thread in the future and are not familiar with Filter queries in Power Automate, refer to this video: https://youtu.be/Ifqo1YKMiw0

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
Gilmour1 62 on at

Like (0)

Report
Copy link

Link copied!

Thank you @rzaneti ,

I revised the flow and I'm still getting the same error:

Action 'Get_items' failed: Column 'S00768' does not exist. It may have been deleted by another user. clientRequestId: 8d8a279b-643d-48fd-b990-906ad39fbf76 serviceRequestId: 42079aa1-1016-c000-a096-58f74fd1aa9d

which doesn't make sense to me. S00768 is the value in a column of the list, NOT the column name.

I've attached a screenshot. Thank you for your help!

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,481 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Gilmour1,

Thank you for sharing the image. Enclose the expression with single quotes (in yellow below):

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
Gilmour1 62 on at

Like (1)

Report
Copy link

Link copied!

@rzaneti, actually your first response worked! Adding the quotes to the second part of the filter query did the trick!

CodeB eq 'CodeA'.

Thank you!

Was this reply helpful? Yes No