Answered

Get-Item from Sharepoint List Doesn't return all fields

(0) Share

Report

Posted on by ET-30071444-0

I'm trying to create a flow that captures the value of a field in a variable for a downstream step but the Get-Item call doesn't return the field of interest.

The list includes a field named FirstNoteDate which is only populated when a related record is entered in a related list and only when it's the first related record in list 2.

It seems straight forward, and I created a flow that runs whenever a note (list 2) is entered. I would then store the Created value from that list as a string variable (date variables are not available). I would then read the FirstNoteDate in the master list and if null, update it with that variable. My flow runs successfully (it never fails) but the FirstNoteDate in the master list never gets updated.

Upon troubleshooting, I realized that the Get-Item call was never returning the FirstNoteDate. If it's pertinent, the FirstNoteDate column was added to an existing list, but is included in the default view.

So before tackling the update step, I need to resolve this problem.

Master List:TicketList, column of interest:FirstNoteDate, Type: Date and time

Related List:Notes, column of interest:Created and TicketListID (to relate to master list record ID)

variable:varNoteDate, type:String

The flow is initiated whenever a new record is added to the Notes list.

Any insight is appreciated.

Categories:

General topics

I have the same question (1)

All responses (5)

Answers (2)

David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Since you didn't share a screen shot of your flow, I need to ask did you configure the get items action to use a specific view? If so, that is most likely why you don't see all the fields. When you specify a view to use, it only returns the fields that are in that view.

Was this reply helpful? Yes No
ET-30071444-0 42 on at

Like (0)

Report
Copy link

Link copied!

I'm using the default view, which I checked and it includes the FirstNoteDate. I also tried creating a more sparse view, which only included the ID, Created, and FirstNoteDate, which also failed to include the FirstNoteDate when called by the Get-Item command.

Was this reply helpful? Yes No
Verified answer

David_MA 14,090 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I would suggest creating a manually triggered flow and add the get items action and point it to your list and set it to return just 1 item. Then add a compose action and put the body of the get items action into it. It will look like this:

Then run the flow and open the flow run and look at the compose action. Copy the data from the outputs and past it into notepad. You can then search for the field in the body to see if the field is being returned. Note, the body will have the internal name of the field and not the display name. If it is not listed, I have never seen this issue unless you choose a view in the limit columns by view option.

Was this reply helpful? Yes No
Verified answer

ET-30071444-0 42 on at

Like (0)

Report
Copy link

Link copied!

Thanks David MA. Your response didn't resolve my issue but led me to the solution. By following your advice to run the Get-Item against a single record, I discovered that the field of interest was NOT returned (even though it was included in the view used). I did a few more tests and realized that it was returned on other records. If the field in question, FirstNoteDate is null (blank) it does not get returned with the Get-Item command. Knowing this I was able to resolve my problem. I do appreciate your insight, as it forced me to rethink my problem, so I'm giving you credit anyway.

Was this reply helpful? Yes No
David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am glad I could help, although even if the field is null, it should be returned in the data as you may want to do logic on certain fields as part of your process to check if they are null such as in trigger conditions. Microsoft documentation states that unless you specify a view, the get items action returns all fields/columns: https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files#limit-columns-returned-by-view

If you see this more often and can reproduce this, you may want to submit a report to Microsoft.

Was this reply helpful? Yes No