Action 'Send_an_HTTP_request_to_SharePoint' flow " Input string was not in a correct format"

(0) Share

Report

Posted on by abbyamante

118

Hello,

i build a flow to get the value of the changes on the sharepoint list columns.

i am using the "Action 'Send_an_HTTP_request_to_SharePoint" to get the Value of the changes. I keep on getting this error "Input string was not in a correct format".

can anyone please help me how to fix this error?

here is my flow and the error im getting:

error raw message

"statusCode": 400,
"headers": {
"Pragma": "no-cache",
"x-ms-request-id": "f2a9f39f-b084-1000-2106-018d52ff74ef",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Cache-Control": "no-store, no-cache",
"Set-Cookie": "ARRAffinity=661bb5a42aa72fa187081047289be23c4e8833591c3737a25cf4a4f79726a2fa;Path=/;HttpOnly;Secure;Domain=sharepointonline-eus2.azconn-eus2.p.azurewebsites.net,ARRAffinitySameSite=661bb5a42aa72fa187081047289be23c4e8833591c3737a25cf4a4f79726a2fa;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-eus2.azconn-eus2.p.azurewebsites.net",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Date": "Mon, 27 Sep 2021 18:09:12 GMT",
"Content-Length": "457",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 400,
"message": "Input string was not in a correct format.\r\nclientRequestId: 06834dc4-536c-46ad-a5cb-83f52cd42e53\r\nserviceRequestId: f2a9f39f-b084-1000-2106-018d52ff74ef",
"source": "https://pharmscript.sharepoint.com/sites/RevenueCycleOperations/_api/web/lists/getByTitle('Facility%20Billing%20Allocation')/items(2951)/versions(1.0)",
"errors": [
"-1",
"Microsoft.SharePoint.Client.InvalidClientQueryException"
]
}
}

here is my current flow set up:

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @abbyamante,

It looks like you are inputting 1.0 as the version value. However, that is the string value of the version. Microsoft expects a number. 1.0 corresponds with 512.

Try this URI instead

_api/web/lists/getByTitle('Facility%20Billing%20Allocation')/items(2951)/versions(512)

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (5)

Report
Hi @abbyamante,

Sorry, I forgot to look at the screenshot.

With your current setup it would be the SinceVersionId field instead of the SinceVersionLabel field.

_api/web/lists/getbytitle('Facility%20Billing%20Allocation')/Items(@{triggerOutputs()?['body/ID']})/Versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})

Was this reply helpful? Yes No
abbyamante 118 on at

Like (0)

Report

@Expiscornovus
thank you for looking into this. when i try to change to what you mentioned above, im only getting the since version number on the dynamic content.

do you know what would be the reason why i only have one option under the dynamic content?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @abbyamante,

I don't know why some don't show up, to be honest :). But you can still retrieve that field though.

You should be able to directly copy paste my last code snippet in the Uri field. Can you try that?

Was this reply helpful? Yes No
abbyamante 118 on at

Like (1)

Report

@Expiscornovus Youre Awesome!! it Works! thank you!

Was this reply helpful? Yes No
rblindt 2 on at

Like (0)

Report

I need some help with a "Input string was not in a correct format. clientRequestId: e91fe4b4-6769-4e52-a713-bfed364ce50c serviceRequestId: e91fe4b4-6769-4e52-a713-bfed364ce50c" error message. Please message me to let me know what information you need to correct this.

Was this reply helpful? Yes No
SaneNobles-RSC 6 on at

Like (0)

Report

@Expiscornovus Thanks! This helped me in a pinch!

Was this reply helpful? Yes No