Power Platform CommunityForums Power Automate - Building Flows Send an HTTP request t...

Send an HTTP request to SharePoint; GET method

(1) Share

Report

Posted on by Community member

My project involves creating an audit trail that captures the previous value of an item in a SharePoint list whenever it is modified. However, when I use the GET method in the 'Send an HTTP request to SharePoint' action, the internal column name (e.g., Volume_x0020_Passive_x0020__x002) gets recoded into Volume_x005f_x0020_x005f_Passive_x005f_x0020_x005f__x005f_x002. This prevents me from fetching the value. Unfortunately, I can't recreate the SharePoint list with proper column names, so I need to find a way to work with the existing ones.

r/MicrosoftFlow - output from action: Get_changes_for_an_item_or_a_file_(properties_only) — output from action: Get_changes_for_an_item_or_a_file_(properties_only)

r/MicrosoftFlow - output from action: Send an HTTP request to SharePoint — output from action: Send an HTTP request to SharePoint

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

Expiscornovus 31,809 Most Valuable Professional on at

Like (0)

Report
Send an HTTP request to SharePoint; GET method

Hi @Community member,

Yes, that is a known limitation/issue of these actions.

You can workaround this by using an expression to replace the underscore character with _x005f_

Below is an example expression

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

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel