nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table widget: only export fields shown in the table, not the entire dataset

Hayley

Is it possible to for the table widget to only export the shown fields in the table rather than all the fields in the layer? I know this is possible for Dashboard widgets so some similar functionality would be super useful.

For example, I only have a few fields selected for this table:

However when I export the table, it gives me the entire spreadsheet with the raw data and even fields I had hidden in ArcPro.

Is there a way to configure this in ExB without having to reconfigure all my layers?

Thanks!

Najděte více příspěvků označených jako

Accepted answers

All comments

JasonBOCQUET

I have no solution but i discover that if you used a table (hosted) type of elements, the table widget export only the fields that you choice.

It seems to be a problem when we try to used the table widget by using a feature service.

I don't know if it helps but this can be a way to use a strict table rather than a feature service (or both linked by group filter/action) ?

KelseyMills

In 2025 and this is still a problem impacting our user base. Is there any plan for a fix on this?

UmutUcok

After 3 years, no solution. It's just a simple column filtering by hidden on runtime. Proposed solutions are useless, huge UX gap to go back to config page and hide some fields. We need to be able to manage them on place.

ahargreaves_FW

@Jianxiaare you aware this issues exists for other widgets that allow tabular exports such as the Query widget? At Exb v11.1 despite my fields being specified I get them all...

Cross posted here also

ScottStepro1

This is still occurring in February of 2024... please update progress. We have been told this has been fixed but clearly has not. thank you.

AngelaSchirck

Thanks, that works great in EB 1.12 dev ed, I was using 1.9 and couldn't eve do that!

BC_Admin509

I found a work around, hopefully this helps. From Experience builder you will need to click on the table and configure the fields once you have the selected fields that you want exported you'll need to follow the steps below.

Select the select icon and highlight the data.
From your table you’ll select the four-circle icon and export selected. You'll know you configured your table correctly when you only see the fields chosen within the table widget.

3. The results should look like this –

AngelaSchirck

So it is now September 2023 (nearly a year since this promise of a Nov 2022 fix) and I STILL do not see this happening. I am using the developers version of Experience Builder (since the enterprise version sucks!) and when I export table it exports ALL the fields, not just the fields selected. When did you say this would be fixed ESRI?!

Hayley

Hi @Jianxia can you please confirm if this has been resolved? When I export from my tables now it honours what is shown in the table

Jason-Daily-Dev

Could you please share how you do this? I made one button widget using local experience builder developer edition, but did not figure out how to add arcgis online. I have some experience application, and want to use this widget.

KrisKarki

Hi Jianxia, I like to prohibit exporting, I could not see any where to set up this in data view. Any help appreciated.

DavidRasner1

The layer view workaround works. Owners will export all attributes (for some reason), everyone else will get only what you see in the table.

The problem is that it also exports auto generated geometry attributes like coordinates for points, or area and length for polygons, which created some confusion for our users.

So currently i gave up on this and made a small microservice that exports clean spreadsheets with a button. Hope you can improve on this in the future. 🙏

Hayley

Hi @Jianxia, how can we disable this?

JianxiaSong

Currently, there is a limitation. When the feature service supports Create Replica operation as shown below, all fields from the layer will be exported regardless the setting in Table.

Hayley

Hi @Jianxia, I have tried exporting from the tables however the issue with all fields appearing in the export still persist. Am I missing something here?

JianxiaSong

The exporting capability in Table will honor the display fields configured in the sheet in the upcoming November release. Thank you for your patience.

Hayley

Yes frustrating.....any updates on this Esri?

We are having to create a large amount of layer views just for this table export functionality

AaronKoelker

This issue is still present as of September 2022. We're using Experience Builder for some emergency response applications, and letting users download certain tables that have been trimmed down to only the fields from the table view would save staff a lot of time in having to trim and format them afterward to meet their needs.

Hayley

Hi Neoh,

Thanks for the update! I just had a play around but found that hidden fields still get exported. It is a good starting point that you can export selected features now, but the real fix would be to only export the fields used in the table.

Exporting selected features:

The fields in the table (only 8):

The export (shows all other fields in the layer):

NeohLiMay

@Hayley @EBaker @JodiWalters

Hey guys, it seems like the issue has been fixed. This is what I saw from my experience.

Hayley

Unfortunately this has not been introduced in the latest update 😞

EBaker

Same problem here, thanks for the info!

Hayley

Thanks for the update!

JodiWalters

Hey Haley - just wanted to let you know I was having the same problem and opened a case. It has now been determined to be a defect and filed as a bug (see number below). I had to escalate it because it is affecting productivity. ESRI did say that the developers are looking into it and it will be fixed in the next release. I asked and the analyst said that will be at the end of June.

BUG-000149879

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.