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 / Using "Limit columns b...
Power Automate
Answered

Using "Limit columns by view" insdie the "Get Items" from SharePoint will return all items

(0) ShareShare
ReportReport
Posted on by 3,506

I have the following "Limit columns by view" inside the "Get Items" from SharePoint :-

 

johnjohn123_0-1660858677581.png

 

 

now the view have 1747 items, but the get items will return all the items and not the ones inside the view.

 

 

any advice on this?

Categories:
I have the same question (0)
  • Verified answer
    Rhiassuring Profile Picture
    8,690 Moderator on at

    "Limit Columns By View" doesn't limit the amount of items, it limits the amount of columns.

     

    Example: if you have Status and Description, and you create a View that's filtered on Status and only shows the Description column, it will still return all unfiltered items, but will only bring back the Description column. (Plus the system columns.) 

    If you want to filter or limit the amount of items, you'll want to use Filter Query.

  • Zinerva2 Profile Picture
    98 on at

    I have the same question but not sure I am understanding your answer. My SharePoint List has a view where it hides certain columns, these are hidden so that my workflow doesn't pull them in the Update Item section, however my Update Item in the flow still pulls the hidden rows. Any thoughts on why this would be? 

    First thought is because they are required fields on the List? 

    Zinerva2_0-1703803473778.png

     

     

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard