Array issue with added underscore in Send an HTTP request to Sharepoint (SharePoint list) from previous versions

(0) Share

Report

Posted on by Ulven

Hi,

I am trying to get previous versions of changes in a SharePoint list when I item is changed

I have followed Reza Dorrani's YouTube-clip: https://www.youtube.com/watch?v=Ek4oYWPWfT0&t

My Flow is like this (it's more up, but this is more important):

Look at the "field_x005f_18" and 20. Why is x005f (underline) getting added when the field name is field_XX?

Best regards

Ulven

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

shoog 2,164 on at

Like (0)

Report

This is SharePoints internal name, where all special characters are converted into codes like this.

You can verify the internal name when you edit the column in SP, you can see the fieldname in the url.

Was this reply helpful? Yes No
Ulven 6 on at

Like (0)

Report

Hi

Thank you. Is there any workaround on this ? Because I am using item() and item()['ColumnNames'] in getting the data and comparing. How can I add x005f or similar to get the correct data?

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report
This is just the way SharePoint created columns having special characters. If you really want to avoid that, create the column name using letters and numbers only and rename it afterwards.

But you can still use it the way it is in Power Automate as long as you make sure you use the internal name when referencing the column in an expression instead of the friendly name, so for example

item()['field_x005f_18']

will work just fine.

Was this reply helpful? Yes No
Ulven 6 on at

Like (0)

Report

Hi again,

Is there an other workaround with use of arrays? A single item is not good enough

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report

Can you give an example of what problem you're running into with arrays and show what the "Select column names" action does?

Was this reply helpful? Yes No
Ulven 6 on at

Like (0)

Report

Yes:
The ColumnName code:
replace(split(item(),':')[0],'"','')
Value:
split(item(),':')[1]
I use "Select column names" and join the body in HTTP req..
and comparing the item values, but the item values are different because of the underscore (I think) and does not get compared with the right column names...any ideas?

Was this reply helpful? Yes No
mwitt 2 on at

Like (0)

Report

Have the exact same issue and its driving me nuts. It really sucks that SharePoint decides to create the internal names this way when creating a list from an excel file and do not expose this until it is to late to fix it, but no I have to solve it for the exact same case as above, so any ideas on how to proceed?

Was this reply helpful? Yes No
tom4112 2 on at

Like (0)

Report

I came across the same issue and simply used a replace function in a Compose action as a workaround (as _x005f_ is the special character for an underscore):

replace(item(),'_','_x005f_')

And then I've referenced the output of the Compose action in the next step instead of using "item()":

coalesce(body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']?[0]?[outputs('Compose')],'')

Was this reply helpful? Yes No