I have a work order app that I use to assign work to individual employees; not more than 1 employee to each job. Iโve had requests to assign multiple employees to individual work orders.
I currently assign work via an โAssigned Toโ enum column where I select the employee name. I have an โEmployee Emailโ column thatโs populated via SELECT expression.
I have a view called โMy Workโ with USEREMAIL() as row filter condition so that employees only see their work.
If I change my โAssigned Toโ column to enumlist, and I assign multiple employees to 1 work order, will they both see it in their individual โMy Workโ view?
Instead of USEREMAIL() you need to use IN(USEREMAIL(), [Assigned To]) as the filter so everyone who is in that list can see the row.
Thank you, sir!!
Bellave, Iโm hoping you can provide some additional assistance with this.
I was using the following expression to populate the [Employee Email] column which worked when it was just 1 employee name being selected from the [Assigned To] column:
ANY(
SELECT(
Employees Master DB[Employee Email], [Employee Name] = [_THISROW].[Assigned To]
)
Now that my [Assigned To] column is an enumlist, the [Employee Email] column gets a โcannot compare text with listโ error.
Any suggestions?
Maybe this could work:
SELECT(
Employees Master DB[Employee Email], IN([Employee Name], [_THISROW].[Assigned To])
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |