Answered

Get item failing

Like (0) Share

Report

Posted on 12 Nov 2018 04:39:58 by Chicko29

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.

I have the same question (0)

All responses (3)

Answers (1)

Chicko29 38 on 13 Nov 2018 at 18:06:10

Like (0)

Report

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!

Was this reply helpful? Yes No
v-yamao-msft on 13 Nov 2018 at 05:52:03

Like (0)

Report

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.

Please share more details to help reproduce this issue.

Best regards,

Mabel

Was this reply helpful? Yes No
Verified answer

PieterVeenstra 11 on 12 Nov 2018 at 12:45:13

Like (1)

Report

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?

Was this reply helpful? Yes No