Download a table from a Data Expression

[PatrickJ2]

On an ArcGIS Online Dashboard, I have a data expression that generates a FeatureSet from a hosted layer and then I make a Table element from that FeatureSet. I have enabled that hosted layer to allow downloads. However, there does not seem to be a way to have the download option on the dashboard table for users. Is it correct that because the table is generated from an expression FeatureSet, instead of directly from the hosted layer, that the download option is not available? Am I missing something that would allow this table to be downloaded by users? If it is not currently possible, is there any plans to add this feature in the future? 

[RobertAnderson3]

I've noticed the same issue, this would be fantastic to add in the future if it's not a setting that we're missing already!

[Rar_Katia]

I'm experiencing the same issue myself. Any news on this?

[Juan_FelipeVillegas]

I have the same question, is that possible?

Were you able to find a solution for that?

[Rar_Katia]

We ended up doing a workaround and granting access to the Feature Set download to those that needed it. Of course, the amended data isn't included. Still hoping there's something the devs can do to implement this, as it would be very helpful!

[diamondu]

This would be an amazing option to have!

[erica_poisson]

I am currently running into this problem. Interestingly, when I use a data expression to create a FeatureSet and use the Grouped Values table type, I can enable download. When I do the same thing, but select Features for the table type, the option disappears. 

@Rar_Katia - how did you execute your workaround?

[Rar_Katia]

Nothing fancy- we just kept the amended table in our dashboard and accepted that the export wouldn't work. Our customer exports the table from the online survey manager instead.

[ReubenWolff · Accepted solution]

I believe that I have found a solution.

It involves using the ArcGIS Online Assistant to edit the dashboard JSON. I have used the ArcGIS Online Assistant before with mixed results. I strongly suggest that you make a copy of your dashboard before making these edits. I have only tested it using Tables that display arcade generated features. I offer no guarantees.  Here's the process that I used:

First get the item id of the dashboard and the name of the table (Edit Dashboard: Table: General: Settings: Name).

Then open ArcGIS Online Assistant https://ago-assistant.esri.com/ and log in.

• Enter the item id of the dashboard into the Search and click enter.
• The search results should only show the one dashboard.
• Select 'I want to View an items JSON'.
• Click on the search results to open the JSON.
• Scroll down to the Data Section.
• Click the pencil icon to edit the JSON
• I use the Chrome 'Find' to search for the Table Name.
• If it finds the table I then scroll down to find:
  • "returnDistinctValues": false,
    "allowSourceDownload": false,
    "allowSummaryDownload": false
• Edit this to:
  • "returnDistinctValues": false,
    "allowSourceDownload": true,
    "allowSummaryDownload": true
• Scroll back up to the top of the Data Section and save your edits.
• Open your dashboard and the table should now have the 3 dots.

This is working for me for both privately and publically shared dashboards.

I hope it works

[Scott_Sambell]

Holy smokes @ReubenWolff .  That actually works.  Absolutely impressive hack!

This open so many possibilities.