Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get SharePoint List Item Does Not Exist

Hi All,


I'm currently having a strange issue with a flow i've already created.  I have a SharePoint list which when a new item is created my flow populates a CSV file with the data required.  The problem I'm having is that the 'Get Items' is having a problem with 2 of the columns and states that they do not exist and in turn cannot populate the data.


Below is the error message i'm getting - The items do exist but i'm a little confused as to why it can't seem to find them.



InvalidTemplate. The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "givenName": "@item()['First_x0020_Name']", "sn": "@item()['Surname']", "Description": "@item()['nhqf']", "department": "@item()['Business_x0020_Unit']['Value']", "company": "@item()['Division']['Value']", "manager": "", "accountExpires": "@item()['End_x0020_or_x0020_Termination_x']", "physicalDeliveryOfficeName": "@item()['Office_x0020_Location']['Value']", "title": "@item()['nhqf']" }'
failed: 'The template language expression 'item()['End_x0020_or_x0020_Termination_x']' cannot be evaluated because property 'End_x0020_or_x0020_Termination_x' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, First_x0020_Name, Surname, nhqf, Employment_x0020_Type, Employment_x0020_Type#Id, Employment_x0020_Status, Employment_x0020_Status#Id, OData__x0061_l34, Division, Division#Id, Business_x0020_Unit, Business_x0020_Unit#Id, Office_x0020_Location, Office_x0020_Location#Id, Telephone_x0020_Required_x003f_, Telephone_x0020_Required_x003f_#Id, Email_x0020_Access_x0020_Require, Computer_x0020_Hardware, Computer_x0020_Hardware#Id, FOCUS_x0020_Access, Building_x0020_Access, Building_x0020_Access#Id, VBA360_x0020_Access, Authorised_x0020_Officer_x0020_P, Inspector_x002c__x0020_Plumbing_, Author, Author#Claims, Editor, Editor#Claims, Modified, Created, {Identifier}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {HasAttachments}'. Please see for usage details.'.
I've tried to duplicate the flow and see if that helped but it just doesn't seem to want to work.. Any assistance would be most appreciated.
Thank you.
Community Support
Community Support

Hi @ DWirth,


Could you please share full screenshot of the configuration of your flow and SharePoint list configuration details?


According to your description and error messages, I couldn't reproduce your mistakes and provide a suitable solution.


Please share more details so we would try to provide a proper workaround for you.


Best Regards,


Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Apologies for the delay in getting back to you.. I wouldn't specifically say someone has made a mistake in their flow when everything else works apart from one field.


Below is an overview of the entire flow:



Once the SharePoint item is created, the flow is triggered.. The first send email collects the data and sends out the email with no problem.

Flow_2.PNGAnd once the email has been sent, the SharePoint list items are then pulled through to create a CSV file.  ALL other items pull through to create the CSV file without any issues BUT the Manager and the Expiration date just won't come through because the system states they don't exist.  This is even though I'm selecting this from the menu that it provides me with.



The above screenshot shows the items that are pulled from the SharePoint list and all work, except the Manager part.  It's very odd why this is the only one that wouldn't work.  This field pulls the manager name from LDAP.


If you need any other information, please let me know.


Thank you

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,147)