Announcements
As seen in the image, is anyone able to tell me where I'm going wrong? I'm trying to make a collection from a select few columns from Table1. The error I get when hovering over is 'Structure' where 'Ident' is expected, Formula contains 'Structure' where 'Colon' is expected. The reason I'm using this formula as there are a few more columns i would like to use from Table1 and then add some new columns that aren't in Table1.
please try below code:
Clear(PatrolsBWFilteredCol); ForAll( Table1, Collect( PatrolsBWFilteredCol, { Structure: ThisRecord.Structure } ) )
Try:
ClearCollect(patrolsBWfilteredcol, Select(table1, "structure"))
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 339 Most Valuable Professional
11manish 180
MS.Ragavendar 88 Super User 2026 Season 1