Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Re: Collection and SharePoint

Hey @leyburn19



That's a nice workaround indeed for now.

Maybe other people will have or have the same problems for this.

So we need to still look for the solution that you want.


Kind regards




Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Super User
Super User

Re: Collection and SharePoint

OK I solved my issue.  I needed to create two collections.   One based on the completed list of Veh and one base on those veh booked based on a filtered date.  Using Forall I then removed all matching records from the Main Veh collection.   This then gave me the result of only a list of vehicles available in the period.  This also soved my probles of how to create a collection based on one column in a share point list.  The Forall became the key in the whole process.  Things I also noted was ClearCollect cannot be used in a Forall.  You alos cannot use removeIF if the Forall is based on the same datasource


This was the syntax below:




ForAll('CAT 2 Defence Vehicle List',If(IsBlank(Title)=false,



View solution in original post

Helpful resources


Power Apps Super User Class of 2020

Check it out!


New Badges

Check it out!


Power Apps Community User Group Member Badge

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


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


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,547)