Hi @Del-Dev
You would have to essentially join them together. If you have the same format between them?
You would either set the Items property and join them there, or pre-join them together in like the OnVisible of the Screen etc.
If they have the same format, then you can do
ClearCollect(MyCurrentCollection, SharePointList)
now since usually a SharePoint list, unless its a custom view, has tons of ugg columns you dont want
ForAll(SharePointList,
Collect(MyCurrentCollection,
{
MyColumn: ThisRecord.SharePointColumn
}
)
);
Now if you dont want to add the SharePoint to your current Collection then do the following
1. Do exactly as I have above in the code sample, but change the MyCurrentCollection, to MyNewCombinedCollection
2. After thats Done, then as long as the New Collection matches exactly the existing one, then just do
ClearCollect(MyCombinedCollection, MyCurrentCollection);
If it doesn't match then you have to do another ForAll to add them to the combined Collection
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
