Share
Report
97I have a user requirement to allow records to be saved with fields not filled out because sometimes some information isn't available during the record creation process. They've come back and now want a report of all of the records that are missing fields and which fields are missing.
I'm currently pulling all of my sharepoint tables into individual collections, but I'm running into a wall for how to create a collection that shows what is missing. Starting with just one of the tables, I created a collection where that was the ID field and a list testing each field. However, what I end up with is a list with a bunch of blank items. I'm sure there is a better way to do this but I'm not seeing how to achieve it.
ForAll(ShowColumns(colDetailsAll,"Title") As StuffStart,Collect(colMissingFields,{IDNumber:StuffStart.Title, Missing:[
If(IsBlank(LookUp(colDetailsAll,IDNumber=StuffStart.Title).Field1),"Field1"),
If(IsBlank(LookUp(colDetailsAll,IDNumber=StuffStart.Title).Field2),"Field2"),
If(IsBlank(LookUp(colDetailsAll,IDNumber=StuffStart.Title).Field3),"Field3")]}));
I could see making a collection that was just:
{ID number: X, "field 3"
ID number: X, "field 6"}
that I could just combine with the group function, but I'm unclear on how I would iterate a record that has a dozen fields into a table with just two fields {title, missing field}. Can someone point me in the right direction for this?
All responses (
Answers (
