Power Platform Community Forum Thread Details

I'm trying to use the "Add a row into a table" action to update a spreadsheet stored on SharePoint, but I cannot get the location to register. When I enter the SharePoint site as a custom value, I get the following error (in the Document Library field):

Could not retrieve values. The dynamic invocation request failed with error: {
"error": {
"code": "invalidRequest",
"message": "Invalid hostname for this tenancy",
"innerError": {
"date": "2023-02-21T20:48:08",
"request-id": "685d977d-66d7-422c-a66f-a161cbed7de0",
"client-request-id": "685d977d-66d7-422c-a66f-a161cbed7de0"}}}.

When I attempt to add the Document Library name as a custom value as well, I get this additional error text:

The dynamic invocation request failed with error: { "error": { "code": "invalidRequest", "message": "The provided drive id appears to be malformed, or does not represent a valid drive.", "innerError": { "date": "2023-02-21T20:53:23", "request-id": "b34d0ef0-e2df-405f-b47b-5d6928421ef9", "client-request-id": "b34d0ef0-e2df-405f-b47b-5d6928421ef9" } } }.

Interestingly, if I use a SharePoint action (e.g. Get file properties) within the same Flow, I am able to copy/paste the exact same URL and Library name as custom values and everything works. And if I modify the URL in the Excel action from contoso.sharepoint.com/subsite1/subsite2 to contoso.sharepoint.com/subsite1, I am able to see all of the libraries in the parent site.

I have verified permissions and connections. Does anyone have any suggestions?

Categories:

Building flows