You’re offline. This is a read only version of the page.
Announcements
41
Despite knowing the syntax being
AddColumns('Portal Comments', "CaseNumberLookup", LookUp(Cases,??A??=??B??, 'Case Number'))
I can not work out how to make it work in my scenario.
I am attempting to creating a table of Portal comments, but I want it to also show the Case Number (Later I will filter from case number).I am struggling to work out what the ID's are which join the tables and how to reference them. Screen shots attached from dynamics.
I suspect since who ever created the relationships originally called them all 'regarding' is making this harder than it should be.
Edit:
Looks like I found a solution.
AddColumns( 'Portal Comments', "CaseNumberLookup", AsType(ThisRecord.Regarding,Cases).'Case Number'
Share
Report
All responses (
Answers (
