Export csv based on a view filtered by useremail

Hello, I have a slice for closed requests that has this expression:

IF(LOOKUP(USEREMAIL(), Directory, Email, Office) = "Users",
AND(IN([Status], {"1", "2", "3", "4"}), USEREMAIL()=[AppUser]),
IN([Status], {"1", "2", "3", "4"}))

showing for accounts with Office = "Users" their requests in status 1, 2, 3 or 4 and for all other users the totality of the requests in status 1, 2, 3 or 4. In the related view I have an action to export it to a csv file and all is right.

Then, I have another slice for open requests that has this expression:

AND(NOT(IN([Status], {"1", "2", "3", "4"})), IN([Companies], SELECT(Directory[Company], [Email]=USEREMAIL())))

showing to users who has their company listed in "Companies" and not having status in 1, 2, 3 or 4

This view shows me the correct data... but when I click on the action to export csv file, the file is empty. 

Why this happens ? Any idea ?

0 2 82
2 REPLIES 2

Have you tried checking the Audit Logs for any errors?

Hello WillowMobileSys,

yes... but nothing is reported in logs.

Top Labels in this Space