You’re offline. This is a read only version of the page.
108
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:
@Expiscornovus Thanks! This helped me in a pinch!
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.
@Expiscornovus Youre Awesome!! it Works! thank you!
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?
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?
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.
Share
Report
All responses (
Answers (
_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']})
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)
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
