Reports that users can customize
This app allows you to select rows according to color and size, and then sends an email report to the provided email address.
Also see: tablet mode & fullscreen mode
How we built this app
To do this, we've got two tables: Data and Report Requests. We created a form view of the Report Requests table, which is what users will fill out to get an email sent to them. We added a virtual column called Matching Items to the Report Requests table with the following formula: SELECT(Data[Name], AND(IN([Size], [_THISROW].[Size Choice]), IN([Color], [_THISROW].[Color Choice]))) That returns a list of rows in Data that has a given size and color. Then, we added a workflow rule for the Report Requests table. The template for the workflow rule looks like this: Found <<COUNT([Matching Items])>> row(s): <<Start:[Matching Items]>> <<[Name]>> (<<[Color]>>, <<[Size]>>) <<End>> That will print a line for each item in the Matching Items virtual column.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.