Get Items SharePoint connector says column does not exist!

(0) Share

Report

Posted on by Flyingfishnm

111

Hi All

A strange one, I get the following error message when the flow is run...

Column 'ApprovalCode' does not exist. It may have been deleted by another user.
clientRequestId: 1599f0f5-1c90-47b4-add4-bcefa1b7749c
serviceRequestId: 1599f0f5-1c90-47b4-add4-bcefa1b7749c

The column does exist. My query looks like this:

(ApprovalWorkFlowID eq '@{item()?['appGUID']}') and (ApprovalCode eq 'A')

what am i doing wrong?

Thanks for any insights

cheers!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Flyingfishnm ,

Basically, column display name and internal name are the same, but sometimes they are not. You can use a Get items action in a single button flow and set top count as 1 to get a single record, run the flow then see all the internal column names from the output:

find the internal columm name in run history:

Best regards,

Was this reply helpful? Yes No
Flyingfishnm 111 on at

Like (0)

Report
Copy link

Link copied!

Hi _Jeffer

Thant fixed the issue, thank you! 😊
Just a follow up question, why does Microsoft allow internal names that are different to the names that a user creates? i understand the spaces in column names but the column name i found was so different to the name I created, I only spotted it via the value i was expecting...

cheers!
dj

Was this reply helpful? Yes No