In this video, I'll show you the step-by-step process on how to retrieve the MULTI-SELECT LOOKUP column values from SharePoint, and create a nicely formatted HTML table to send by email! Formula used in the video: join(xpath(xml(json(concat('{"body":{"value":', item()?['YOUR-LOOKUP-COLUMN-HERE'] , '}}'))), '/body/value/Value/text()'), '; ') Follow me for more goodness: Twitter: @veronicageek Blog: https://veronicageek.com Github: https://github.com/veronicageek