Is there any way to select all column to retrieve in 'Get List Item' SharePoint List activity?

[tavinee.i.tv (Tavinee)]

Hi,
I want to select all columns to retrieve in ‘Get List Item’ SharePoint List activity.
That has a lot. When I select one, the step is refresh every time so it will took a lot of time to select every column one by one . Is there any way faster to select all option than select one by one?

Thanks.

[prashant1603765 (Prashant Kumar)]

Hi @tavinee.i.tv

There’s no direct “Select All” in this

To get all columns faster, try leave the Fields parameter empty or blank this retrieves all columns by default.

Alternatively, use Get List Items activity without specifying columns to fetch full items.

FOR MORE:
Activities - Get List Items

[tavinee.i.tv (Tavinee)]

This step can’t leave the field as blank (no select)
Error is shown as ‘You must provide a value for Columns to retrieve’

[prashant1603765 (Prashant Kumar)]

Pls update the latest package - 3.0.14 and use like below,

[sharazkm32 (Sharaz K M)]

I do have a workaround for reading all the rows from a share point list.

1. Go to Share Point list manually
2. Either go with All Items or create your own view with required filters in place
3. Click on export to excel option

4. catch is that the file is not exported in excel, Instead a live iqy file. Everytime we open this file - it will be updated with the latest details from SharePoint

5. Keep this exported iqy file in your project folder

6. Use excel application scope and read this iqy file.You can do all the filters and operations after reading this file and using data table filter activity.

[Anil_G (Anil Gorthi)]

@tavinee.i.tv

If you can you can try using classic activities instead of modern for o365 that does not need columns to be specififed

Or other way is export the list from sharepoint and you will get all column names in excel just use an excel formula to append all together with comma and double quote separation and use that in the columns to retreive field New String() {"value from excel formula"}

Cheers

[postwick (Paul Ostwick)]

This is not a good solution. Using the activities (API) instead of UI automation is the better way.

[sharazkm32 (Sharaz K M)]

Agree. API is better

This will also work as expected similar to excel automation.