Cross posting from stackoverflow as I think this is a SharePoint issue...
When I check my collection, all desired columns are shown, including columns with a null value. When I check the ProfileData variable passed through the JSON function, the columns with null values have been dropped out. Is there a way to get columns with null to stick in the ProfileData variable?
I learned that pointing the app at an excel spreadsheet will include null attributes, but pointing it at a sharepoint list will excluse null attributes. Any ideas on how to include attributes with null values from a sharepoint list?
//Clear the existing profile collection Clear(ProfileContent); // Loop through each item in ProfileContent and collect the file data Collect(ProfileContent,ShowColumns(CurrentItem, First,Last,Middle,Phone,Class,Score,Grade) ); // Set the ProfileData variable with the JSON representation of ProfileContent Set(ProfileData, JSON(ProfileContent,JSONFormat.FlattenValueTables)) 
Set(ProfileData, JSON(ProfileContent))