Replace special characters of list name to make it compatible to use in Send HTTP Request to SharePoint action

(0) Share

Report

Posted on by rameshmukka

1,115

Hello everyone,

I have a list whose name is "SOX - PO without PR (YPONR) Tasks". I am trying to create a task within this list using Send an HTTP Request to SharePoint action as I have few hyperlinks to populate. I am confused how to specify the name of the list in the body of the action

__metadata": { "type": "ListNameListItem" }

I know spaces can be replaced with _x0020_ but not sure of special characters like "-" (hyphen), "(" and ")". How do I encode these here and what should they be replaced with? I couldn't find any documentation regarding this. We don't want to change the list name.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (2)

Verified answer

Paulie78 8,422 Moderator on at

Like (2)

Report

Take a look at this blog post I did yesterday:

How to Encode SharePoint Column Display Names to Internal names

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report

This one would also be useful to you:

https://www.tachytelic.net/2021/03/update-hyperlink-column-sharepoint-power-automate/

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report
@Paulie78
You did a great job in both the posts. I bookmarked them for future use. I was waiting such content since long time. Your form generated me blow json but it fails somehow. I tested with simple list called "TestList" and it works fine. Here is the screenshots

{ "__metadata": { "type": "SP.Data.SOX_x0020_-_x0020_PO_x0020_without_x0020_PR_x0020__x0028_YPONR_x0029__x0020_TasksListItem" }, "RelatedItems": { "Description": "Microsoft", "Url": "https://www.microsoft.com" } }

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report

Please go to the list in your browser and copy and paste the URL here. Then we can figure out what the list name should be.

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report
Here is it

/sites/rameshtest/Lists/SOX%20%20PO%20without%20PR%20YPONR%20Tasks/AllItems.aspx

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (1)

Report

Hey @Paulie78
I just figured it out. I replaced all %20 with _x0020_ and it worked. You blog posts came to great rescue. Thank you so much.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

I think the list name would be:

SOX_x0020__x0020_PO_x0020_without_x0020_PR_x0020_YPONR_x0020_Tasks

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report

Well done @RameshMukka

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @RameshMukka,

Hope you guys don't mind that I bud in.

You can also retrieve the correct value for the type field by retrieving the ListItemEntityTypeFullName value via an additional HTTP request action. Saves you a bit of manual encoding time 😉

Below is an example of such an approach.

1. First collect the ListItemEntityTypeFullName value of your SharePoint List. Replace/set the ListName variable by the name of your current list name.

2. Use the following Body to create a new item. You can use an expression to get to retrieve the correct entitytypefullname.

{ "__metadata": { "type": "@{outputs('Send_an_HTTP_request_to_SharePoint')?['body/ListItemEntityTypeFullName']}" }, "Title": "Testing Promoted Links", "LinkLocation": { "Description": "Microsoft", "Url": "https://www.microsoft.com" } }

Was this reply helpful? Yes No
MalekFCH 7 on at

Like (0)

Report

Hello Paulie,

this link is just amazing but i'am looking for this specific caracter : '°' and i can't find it
do you have any idea about how can i replace it ?

Was this reply helpful? Yes No