Power Platform Community Forum Thread Details

Hello Everyone,

I am building a Safety Audit Form PDF and have been trying to do this for days now. Basically for everyone machine we do an audit on we have multiple zones with multiple action items for safety. When I insert into sharepoint each audit I grab those values into a pdf document, however, I want only unique values of my Zones column. Basically I want Zone 1 to return Contractor Safety and Chemical & Material in the same Row.

So then I built a complex HTML table to do this as well as created a lookup unique table of Zones. My issue is though some machine don't have 3 zones or 4 so my concat column of Zones in the HTML table will still return zones 3, and 4 even though my fact table doesn't contain those. How do I add a filter between tables like a left outer join or something to do this?