You’re offline. This is a read only version of the page.
Announcements
97
I 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?
Power Apps just isn't setup to iterate across fields in this fashion. There really isn't a better way to do it in Power Apps, it's more of a question of using the right tool for the job.
That said, you could improve performance by using a With() statement instead of running LookUp() repeatedly. You could filter the table before adding to Missing: to remove the blanks.
Since it is more a data reporting request, depending on the customer requirements, consider using Power Query (either from Excel or Power BI) to mash up the data and view it somewhere else.
Share
Report
All responses (
Answers (
