I want to put this out, for anyone who like me, finds millions of examples of code, but then CAN NOT GET IT WORKING.
So here is what I have the SPLIT FUNCTION
always using RESULT like ).Result or Name: Result etc.... ALWAYS GAVE ME AN ISSUE!
When I changed it to .Value or Name: Value works like a champ. WHY ?????
Here is the code difference
THIS WORKS!
ForAll(colAttachmentLogList As HC,
ForAll( Split(HC.AttachmentNames, ",").Value,
Collect(colAttachmentLogList2,
{ Title: HC.Title, CreatedDate: HC.CreatedDate, Officer_Name: HC.Officer_Name, AttachmentNames: Value }
)
)
);
This SHOWS the "RESULT" as NOT RECOGNIZED
ForAll(colAttachmentLogList As HC,
ForAll( Split(HC.AttachmentNames, ",").Result,
Collect(colAttachmentLogList2,
{ Title: HC.Title, CreatedDate: HC.CreatedDate, Officer_Name: HC.Officer_Name, AttachmentNames: Result }
)
)
);