Preview App As to Generate CSV File

[eyadiii]

I have an EXPORT THIS VIEW TO CSV FILE action and linked to Slice Actions. I already set the table slice (the row filter is: OR([Agent Email] = USEREMAIL(), [TL Email] = USEREMAIL(), [Manager Email] = USEREMAIL())) where USEREMAIL() is equal to either Agent, TL, or Manager Email columns in the Masterfile table.

I wanted to check if the generated file is equivalent to the slice but it did not. The file shows my rows but not Preview App As's email.

[Aurelien]

Hi @eyadiii 

In the preview pane, the app editor's credential might be used instead of the "preview app as" credential.

This includes USERROLE() which always return Admin for example.

I assume it is being ignored for the CSV export as well, I remember having ran into that a while ago.  For this specific case, you may want to ask the final user to give it a try.

You may want to file a ticket to report this issue though: Contact Us - AppSheet Help

[eyadiii]

I tried changing up the values in [Agent Email] to the email I used for Preview App As, so when I generate a CSV file, no rows appeared. When I changed all [AgentEmail] to mine, all rows appeared. But, they are in random order, not following the order in the app view. Is there a way to fix it too?
I guess it's working accordingly to the formula I used. I haven't deployed the app yet/give trials for the users. Maybe Preview App as only gets to view the interface and not use the actions. But the weird part is, when I change the email to a Team Leader's email (in Preview App as), the approve and reject buttons work.
And no, I did not use USERROLE() for this, but have a spreadsheet for the approval level and security filter.

[Aurelien · Accepted solution]

---

@eyadiii wrote:

But, they are in random order, not following the order in the app view. Is there a way to fix it too?

---

I don't think so, as the sorting is something you perform on the view and not on the data itself.

Can you confirm that visually in your app, you are having the result expected, i.e. you see the records you expect to see when preview app as someone specific?

If so, the csv file export should work as expected. As I said earlier, you need to give it a try to someone who is not you.