Forum Discussion

Stefaan De Vreese's avatar
Stefaan De Vreese
Brass Contributor
Aug 06, 2018

Flow on Sharepoint List View not fetching correct fields

Hi,

 

I'm trying to get all the records/columns using a view on the Sharepoint List.

 

the custom view I created on this list only has those two columns. And yet FLOW retrieves completly different fields from the list:

 

InvalidTemplate. The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "FileNr": "@item()['EOTAFileNr']", "adoption date": "@item()['EADAdoptionDate']" }' failed: 'The template language expression 'item()['EADAdoptionDate']' cannot be evaluated because property 'EADAdoptionDate' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Title, EOTAFileNr, RelatedProductGroup, RelatedProductGroup#Id, RelatedManufacturer, RelatedManufacturer#Id, PublishStatus, PublishStatus#Id, {Identifier}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {ContentType}, {ContentType}#Id, {HasAttachments}'. Please see https://aka.ms/logicexpressions for usage details.'.
 
Why is it retrieving all these fields I didnt even include in the custom view??
Microsoft Flow
sharepoint

3 Replies

  • Kerem Yuceturk's avatar
    Kerem Yuceturk
    Icon for Microsoft rankMicrosoft
    Aug 07, 2018

    Hi Stefaan De Vreese, thank you for reporting this issue. We have a fix in the works and it will be deployed to all customers over the coming weeks. Hopefully by mid to late August. 

     

    Sorry about the inconvenience.

    • GG1211's avatar
      GG1211
      Copper Contributor
      Nov 30, 2018

      hi,

       

      Was the fix deployed for 'Flow on Sharepoint List View not fetching correct fields' issue? In case yes, please provide links/details.

       

    • Stefaan De Vreese's avatar
      Stefaan De Vreese
      Brass Contributor
      Aug 08, 2018
      Thanks, I hope it will be fixed soon, because this is a deal breaker for the solution we try to implement for our client.