cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

 

 

Tom





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:

 

Clear(AllV);Clear(AllB);

ForAll(Bookings,If(DateTo<=Today(),Collect(AllB,{Rego1:Rego})));

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

Collect(AllV,{Rego2:Title})));

ForAll(AllB,RemoveIf(AllV,Rego2=Rego1))

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

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

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