Empty columns not being pulled through

(1) Share

Report

Posted on by CU09061057-0

Hi,

I'm trying to pull data from a sharepoint list using Power Automate, which has a about 30 columns but the columns that don't have data in them are not being pulled through. How do I pull out all columns including the ones with no data in?

Is there also a way to pull only the columns shown in the sharepoint list, not the system generated columns that are not visible in the sharepoint list (attachment)

Thank you in advance!

Tyra

Categories:

Building flows

Screenshot 2025-0...

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,392 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU09061057-0

So just to... say, you intially said have no dated, which meant were there but blank (which it will always pull through), then you said like the picture, and they aren't added to the View.

No, you cannot pull through columns that are not part of the view. You would have to create a view that has the columns you want, as it appears your default on is lacking the ones you want even though they are blank.

Maybe silly but why not just add them? I mean you could add them and hide them, which is not the same thing as removing them, but they would be there, just hidden and should show up for you which is what you want.

Was this reply helpful? Yes No
CU09061057-0 7 on at

Like (0)

Report

Hi Michael,

Thank you for your response!

So there's two separate questions:

1. The blank columns are apart of my view. I want to pull all headers and data from my sharepoint list however some of my columns haven't been populated with data - so they are completely blank with a column header. I noticed these columns were not being pulled through to the output file. I want these to be pulled through as well so I would have the column headers as these may be populated in the future, but I'm unaware of how to do this?

2. For the columns that have been pulled through, the system generated columns (not visible in the sharepoint list as I didnt create them) are being pulled through into the output file. Is there a way for me to exclude these columns before it's put into the output file?

Thanks again

Tyra

Was this reply helpful? Yes No
CU09061057-0 7 on at

Like (0)

Report

@Michael E. Gernaey

Was this reply helpful? Yes No
Michael E. Gernaey 53,392 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU09061057-0

Can you please share a picture of your view. black out the data thats fine.

But if you do not want certain columns then in your flow assuming you are using get items, you can create a View that only has the columns you want and it should NOT pull back the system ones (under advanced).

So... I am .. not sure why you are not seeing the other data, I'd have to see a picture of the JSON being returned from SharePoint.

But I would need a specific view to do what you secondarily asked or you get it all. Truly, if the column is added to the row, it should show up data or not.

now in Power Apps (Canvas App) columns that are not used, aren't pulled back, but that's not the same thing exactly.

Create the view with everything you want

run it

share the JSON output from GetItems

Cheers

Was this reply helpful? Yes No