cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NYaard
Level: Power Up

Flow not including recent sharepoint list items

Hi everyone

 

I recently created my first flow, which is connected to a sharepoint list.

 

The flow is used to send out a mail every monday to friday.

It takes the sharepoint list and filters depending on values in two columns in a FilterArray

Then it extracts certain columns in a Select module and creates it into a HTML table to finally be sent by mail if the content is not empty.

 

The flow works fine for some items in the sharepoint list, however, it seems as though some items are not included even though they are in the list. This especially applies for recently created items. Mostly items, which already existed when the flow was created, are extracted from the sharepoint list, while others are just voided.

 

The "Get Items" module links to the specific sharepoint site and list name, but has no filters.

test

I thought it might be a a result of a limit to how many items can be loaded to the flow, but even with a "Limit Columns by view" the new items still do not appear.

 

Does anyone know why some items are not extracted in the Get Items module while others are?

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
NYaard
Level: Power Up

Re: Flow not including recent sharepoint list items

I found the issue 🙂

It was due to the default limit of 100 items in "Get Items". It worked to set the limit up to the maximum of 5000.

View solution in original post

1 REPLY 1
NYaard
Level: Power Up

Re: Flow not including recent sharepoint list items

I found the issue 🙂

It was due to the default limit of 100 items in "Get Items". It worked to set the limit up to the maximum of 5000.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 463 members 6,541 guests
Please welcome our newest community members: