Power Automate / rename columns sharepoint list

(0) Share

Report

Posted on by jpr23

Please , i would like to rename some columns of a sharepoint list using a flow power Automate .

Is it possible ?

I saw the function send HTTP in a posted topic but i don't know how does it works.

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jpr23

Here is sample flow:

Uri:
_api/web/lists/getbytitle('<List Name>')/Fields/getbytitle('<Old Column Name>')

Headers:
{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose", "IF-MATCH": "*", "X-HTTP-Method": "MERGE" }

Body:
{
'__metadata': {
'type': 'SP.List'
},
'Title': '<New Column Name>'
}

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
jpr23 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

it works well ..thank you very very much !!!!
I notice that the column is renamed but the initial name of the column is still the same.

I have two further questions before closing the topic :
1) If the flow doesn't find the column name an error occure and then the flow is stopped. How can i test that to avoid the stop ?
2) if i want to rename many columns , do i have to copy the send HTTP request again and again or can i send one request for all ?

Thanks..

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

1) If the flow doesn't find the column name an error occurs and then the flow is stopped. How can i test that to avoid the stop ?
--> get columns list from SharePoint and check required column name exist or not.

2) if i want to rename many columns , do i have to copy the send HTTP request again and again or can i send one request for all ?
--> loop it.

Was this reply helpful? Yes No
jpr23 45 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks , yes of course i can have a loop "apply to each" . So I defined 3 variables .
but what is the syntax to replace list_name , old_colum_name et new_column name by these variables in the request please ?
_

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Store the old column name and new column name in excel/sharepoint list. Now get the values(i.e. old and new column) and loop it.

Was this reply helpful? Yes No