
Announcements
Hi,
Wandering what best approach is for following scenario.
I have 3 seperate Sharepoint lists with a single column that is a lookup column, I require.
These will be populated into a combo box.
There could end being 5,000 records down the track.
Would the best approach be to create a collection or use add columns?
Thanks in advance
Todd
Hi @Tango ,
I think, using addCollumns, the formula would be simpler. You could directly add related columns of other tables to the table with the lookup column. And ClearCollect is a behavioral function, it cannot be put directly in the combo box and needs to be put in the OnStart of the app.
Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.