'Get Items' does not return all columns in Sharepoint List

[ericonline]

Has anyone faced this before? What am I missing?

Scenario1:

• Trigger: Button push
• Action1: Get Items from Sharepoint List
• Action2: Create .csv (automatic headers)
• Action 3: Send email (with .csv as attachment)
• Works fine EXCEPT there are columns missing from the Sharepoint list (6 columns!)

Scenario2:

• Trigger: Button push
• Action1: Send HTTP Request to Sharepoint list
  • GET with _api/web/lists/GetByTitle('LISTNAMEHERE')/items as the "Uri"
• Action2: Parse JSON (parse the response from above)
• Action3: Compose (grab the nested array from JSON using outputs(['ParseJson']?['body']?['d']?['results']
• Action4: Create CSV (from Body of Compose action)
• Action5: Send email (with .csv as attachment)
• Works fine and returns ALL COLUMNS in the Sharepoint list

Why partial results with Get Items?

Thank you

[MuffinRanger]

For me, it was because there was no values for that column in any of the rows, once 1 or more rows contain values the column returned correctly.