Renaming columns in a collection

(0) Share

Report

Posted on by azizrasul

124

I have a MS SharePoint list (SP1) where the column headings are

First Name

Last Name

DOB

Address

Post Code

Colour

_PoweAppsId_

However when I create a collection based on the MS SharePoint list, the field names are different e.g.,

ClearCollect(NewCollection,ShowColumns(SP1,"Title","field_1","DOB","field_2","field_3","field_4","field_6"))

How do change the above ClearCollect line so that I get the same column names as in the MS SharePoint list.

I'm ultimately creating a flow, using Power Automate, to output the collection to a CSV file and at the moment I'm getting the CSV column names

Title

field_1

DOB

field_2

field_3

field_4

field_6

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

NPrice99 1,302 on at

Like (0)

Report

Hi @azizrasul
What are the names of the fields in the sharepoint list ?

These can be found by going to the list settings, if you are using content types, click on "Content Types" or just click on the column and at the right hand side of the url you will find the Sharepoint field name.

You should then be able to use "Rename_column" in a ClearcOllect or Collect to change the field names.

Regards

Nigel

Was this reply helpful? Yes No
WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report

Hi @azizrasul ,

You have created this list by importing an Excel spreadsheet, which has the unfortunate effect of setting the "original" name of the columns field_x. This will cause you a lot of ongoing grief and confusion- I suggest you re-create your list with the names you actually want and paste in the Excel Data afterwards (you can do this in SharePoint "Edit in grid view" about a 100 records at a time) or if you have thousands of records, with Power Automate.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

1 people found this reply helpful.

Was this reply helpful? Yes No
azizrasul 124 on at

Like (0)

Report

The names of the column headings are what I want in the SharePoint list. The problem is that the field names change when I create the collection using the SharePoint list as my data source. Hence, I'm not pasting in the data as the data will change from day to day.

Was this reply helpful? Yes No
azizrasul 124 on at

Like (0)

Report

First Name
List=%7BAEBC1FFB%2D0495%2D4CE7%2D9B38%2DC2C2C8E7D7AB%7D&Field=Title
Last Name
List=%7BAEBC1FFB%2D0495%2D4CE7%2D9B38%2DC2C2C8E7D7AB%7D&Field=field%5F1
Address
List=%7BAEBC1FFB%2D0495%2D4CE7%2D9B38%2DC2C2C8E7D7AB%7D&Field=field%5F2

How would I use the RenameColumns with ClearCollect?

Was this reply helpful? Yes No