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 (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 (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 (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 (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 (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