Power Platform Community Forum Thread Details

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

Categories:

Power Apps Pro Dev & ISV

Well, without being able to see your flow I am not totally sure, but your error message seems fairly clear.

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.