You’re offline. This is a read only version of the page.
Announcements
Dear Team,
I am converting csv to xlsx file when clicked excel icon in powerapps. I have custom flow which is converting csv data into xlsx but unable to bulk update the xlsx sheet with Send Http request.
Can anyone share how i can resolve the issue.
I have used add rows to update the excel file but its getting timeout.
Error Message:
{
"status": 400,
"message": "The expression \"web/GetFolderByServerRelativeUrl/('TestLibrary')/items(%2fTestNewDocLibrary%2fTest05_05_2023T13_13_22Z.xlsx)\" is not valid.\r\nclientRequestId: 715eeeb0-18ae-419d-85e3-7edcc3c69840\r\nserviceRequestId: 8ce3afa0-2070-d000-f395-cde23071e14f",
"source": "https://test365.sharepoint.com/sites/Test_Dev/_api/web/GetFolderByServerRelativeUrl/('TestLibrary')/items(%252fTestNewDocLibrary%252fTest05_05_2023T13_13_22Z.xlsx)",
"errors": [
"-1",
"Microsoft.SharePoint.Client.InvalidClientQueryException"
]
}
Regards,
Powerapps Team
Well, without being able to see your flow I am not totally sure, but your error message seems fairly clear.
Share
Report
All responses (
Answers (
4,702
The expression \"web/GetFolderByServerRelativeUrl/('TestLibrary')/items(%2fTestNewDocLibrary%2fTest05_05_2023T13_13_22Z.xlsx)\" is not valid.
So something about the message you're sending doesn't make sense to SharePoint. I've never looked at a request like this before, but it does look strange to me. Why would the request be getfolderbyrelativeurl, but then the end of the request is asking for a file? And why would you have two different libraries named and nested in the request (testlibrary and testnewdoclibrary)? I think you have made errors in your power automate action and simply need to review it.
