web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Missing Columns from S...
Power Automate
Unanswered

Missing Columns from Sharepoint List

(0) ShareShare
ReportReport
Posted on by 10

Hi there,

i have the task of creating a PDF export that contains all values of a Sharepoint list. I got the basic thing to run, however, i am running into an issue with missing columns from the Sharepoint list. When i do the "select" operation to map the values from the List Columns, not all Columns from my Sharepoint List are provided via the "Get Items" action.

Now, I have tried to change the "Limit Columns by View" Info in the "Get Items" operation. I can change it to the "All Items" view, which contains all columns, but this does not give me the missing ones. If I try to set it to "Use all columns (Do not limit)", it does not even keep this value after saving the Flow, it reverts back to blank.

 

I also tried to re-create these columns and added some new ones, but also these do not show up in the flow.

 

Now, I need to have all Columns data in this report. what can i do to solve this issue?

 

many thanks in advance!

Categories:
I have the same question (0)
  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @nicolaspuetz ,

    after the "Get items" action, please try to add a "Compose" action and see if you're able to grab all the columns.

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

  • nicolaspuetz Profile Picture
    10 on at

    Hi Marco, no, I dont, i get the same choice of columns as in the Select action

  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @nicolaspuetz ,

    if you're not able to grab the required columns via dynamic content, please use the following expression for each missing column:

    item()?['column_name']

    So, for example, if you're missing the Title: item()?['Title']

     

    MarconettiMarco_0-1660648352028.png

     

    If I have answered your question, please mark my post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

     

  • nicolaspuetz Profile Picture
    10 on at

    hi @MarconettiMarco ,

     

    i tried this, but the result seems empty. I tried both the column name as well as the technical name, the column has (see screenshot).

     

    the flow runs successful for both attempts. but in the Pdf, the data is empty:

     

    Screenshot 2022-08-16 132644.png

  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    ok @nicolaspuetz ,

    can you share the full flow in edit mode?

     

    BR,

    MArco

  • nicolaspuetz Profile Picture
    10 on at

    Screenshot 2022-08-16 132947.png

  • nicolaspuetz Profile Picture
    10 on at

    hi @MarconettiMarco ,

     

    i found my issue. i am terribly sorry. I referenced an older version of the list in the "Get Items" action which almost has the same name!

     

    again sorry for stealing your time and many thanks for your help!!!

     

    will delete this post to not further confuse others!

  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @nicolaspuetz ,

    no problem, you're welcome.

     

    BR,

    Marco

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard