Hi all,
This is probably going to end up becoming a support ticket, but I figured I'd check here first.
I am currently using a slice to produce a customizable .xlsx file. The slice has a number of criteria that the user can change to get to their desired data set. Currently, this is done on a dashboard with a detail view w/ quick edit fields on one side and a Table view of the slice on the other. Once the user has their criteria set they can generate a report using an action that triggers a bot. When the bot is done they can download that file with a separate action.
The issue is that when I select multiple options in an EnumList field that is one of the criteria, I will get the correct data in the Table view of the slice but return a table with no data (<<templateReference:id=1>>) on the .xlsx report (everything works correctly when you only select one item in the EnumList). Here is the piece of the slice that deals with an EnumList field:
IF(ISBLANK(SELECT(Users[Building],USEREMAIL() = [Email])), True, IN([Building],SELECT(Users[Building],USEREMAIL() = [Email])))
[Building] is a Ref field on the sliced table, Users[Building] is a EnumList base type Ref.
Any help is appreciated, if you have any questions please let me know.
Thanks!
LinkedIn
Twitter
