Email a list of non-empty fields in a Sharepoint list
I have a sharepoint list that contains 400+ colums of data. Any of these columns may or may not contain data. I have tried using "Select" to map the header to the value of each column, and then use "Create HTML Table", but it lists all 400+ headers horizontaly in the email even if the Column is empty. Is there a way to list only the cloumn headers where the column contains data? Or maybe a way to list the table vertically so it is readable in the email. My goal is to send an email of inventory items that were used to a person so he can restock the items that were used.