Template
Custom reports
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.
Loading...
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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...