Answered

German Characters in Filename + Power automate Sharepoint GET FILE connector

(1) Share

Report

Posted on by FelixK

I have a flow that uses a excel for business table with an apply to each.

This flow get a file from sharepoint based on the path and file name in the excel table item and then sends it to a HTTP Rest API.
Overall this works, but as soon as the FileName includes a special german character e.g. ä,ü etc the sharepoint get file connector fails with:

{

"status": 400,

"message": "Cannot open file \"Änderung Ausbildungsverhältnis_0f573474-e1dc-4e96-b217-9a974b88f993.PDF\".\r\nclientRequestId: 9e63b48f-a1fc-4481-babc-0f96907d5c18\r\nserviceRequestId: 9e63b48f-a1fc-4481-babc-0f96907d5c18"

}

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Sort by

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @FelixK

Instead of using "Get file" action you could try to use following steps:

1) Create a variable to store File path (FileURL).

2) Use "Send HTTP Request to SharePoint", encoding the previous URL:

3) Parse the output of that action to get file id or other properties you may need.

Hope that helps!

Ferran

Was this reply helpful? Yes No
FelixK 36 on at

Like (0)

Report
Copy link

Link copied!

i got a authorization issue now.
Note:
When i use the URI Path in the browser, i can access the file.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @FelixK

Please, check that the URI content contains only the path to the file (/Documents/....) and NOT the full path (https://...)

Ferran

Was this reply helpful? Yes No
FelixK 36 on at

Like (0)

Report
Copy link

Link copied!

This is what i put into the "Send an HTTP request to SharePoint"

{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "HttpRequest"
},
"parameters": {
"dataset": "https://haufegroup.sharepoint.com/sites/CLEVISHPOPs",
"parameters/method": "GET",
"parameters/uri": "%2FShared%20Documents%2FKundenprojekte%2F00_Austausch%2FVertraege%2FPER-001002%2FNachtrag%20zum%20Arbeitsvertrag_13.08.21.pdf"
}
}

The OUTPUT of this is:

{
"status": 401,
"message": "401 UNAUTHORIZED\r\nclientRequestId: 4dda5848-196e-4e07-9bcc-36d5cffe463e\r\nserviceRequestId: 418ab8a0-a0b2-6000-b366-c3dea68a818b",
"source": "https://haufegroup.sharepoint.com/sites/CLEVISHPOPs/%2FShared%20Documents%2FKundenprojekte%2F00_Austausch%2FVertraege%2FPER-001002%2FNachtrag%20zum%20Arbeitsvertrag_13.08.21.pdf",
"errors": []
}

Note: If i copy the Source URI( https://haufegroup.sharepoint.com/sites/CLEVISHPOPs/%2FShared%20Documents%2FKundenprojekte%2F00_Austausch%2FVertraege%2FPER-001002%2FNachtrag%20zum%20Arbeitsvertrag_13.08.21.pdf) into the browser it opens up the file .. so the URI seems to be valid?!

Was this reply helpful? Yes No
FelixK 36 on at

Like (0)

Report
Copy link

Link copied!

what is expected as URI here .. from other posts i read something like this start:

_api/web/sitegroups....

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Could you try without encoding the URL? (just using the path with special characters). Definetely, SharePoint doesn't like those special characters!

Was this reply helpful? Yes No
FelixK 36 on at

Like (0)

Report
Copy link

Link copied!

Nope,

this is the Input:
{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "HttpRequest"
},
"parameters": {
"dataset": "https://haufegroup.sharepoint.com/sites/CLEVISHPOPs",
"parameters/method": "GET",
"parameters/uri": "/Shared Documents/Kundenprojekte/00_Austausch/Vertraege/PER-001002/Nachtrag zum Arbeitsvertrag_13.08.21.pdf"
}
}

still got this return:

{
"statusCode": 401,
"headers": {
"Pragma": "no-cache",
"Cache-Control": "no-store, no-cache",
"Set-Cookie": "ARRAffinity=2b32c941e87fc70dc161f1125535279f54f62986d944c59b80b03a276f731b44;Path=/;HttpOnly;Secure;Domain=sharepointonline-ne.azconn-ne-002.p.azurewebsites.net,ARRAffinitySameSite=2b32c941e87fc70dc161f1125535279f54f62986d944c59b80b03a276f731b44;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-ne.azconn-ne-002.p.azurewebsites.net",
"x-ms-request-id": "138db8a0-20d7-6000-b366-cd88778fa33c",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Thu, 01 Jun 2023 11:07:45 GMT",
"Content-Length": "368",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 401,
"message": "401 UNAUTHORIZED\r\nclientRequestId: 0c0b0137-8a3e-4088-aeff-e8166e9ecdd9\r\nserviceRequestId: 138db8a0-20d7-6000-b366-cd88778fa33c",
"source": "https://haufegroup.sharepoint.com/sites/CLEVISHPOPs/Shared%20Documents/Kundenprojekte/00_Austausch/Vertraege/PER-001002/Nachtrag%20zum%20Arbeitsvertrag_13.08.21.pdf",
"errors": []
}
}

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @FelixK

At the very first question you were asking, which action are you using? Honestly, I tried using get file content using path action on a file with german characters and worked like a charm:

So I'm not sure if it's something about german characters or something about that specific file. Could you try with a different file using the same action I used?

Regards,

Ferran

Was this reply helpful? Yes No
FelixK 36 on at

Like (0)

Report
Copy link

Link copied!

I tried with various Files and these three connectors
They fail when i use a variable as a Path input for the connector with a value like: "/Shared Documents/Kundenprojekte/00_Austausch/Vertraege/PER-007649/Änderung Ausbildungsverhältnis_0f573474-e1dc-4e96-b217-9a974b88f993.PDF"

if i navigate to this particular file in the connector and select it manually not using a variable, then the file is loaded successfully.

NOT WORKING:

WORKING (if path is manually selected):

But of course I want to use a variable, as i need to loop this trough a couple of 1000 documents...

Was this reply helpful? Yes No
FelixK 36 on at

Like (0)

Report
Copy link

Link copied!

So if i use this the encodeURIComponent function it returns

%2FShared%20Documents%2FKundenprojekte%2F00_Austausch%2FVertraege%2FPER-007649%2F%C3%84nderung%20Ausbildungsverh%C3%A4ltnis_0f573474-e1dc-4e96-b217-9a974b88f993.PDF

If i use this in a Browser tab, i can´t open the file, and the power automat flow returns the following error:

"message": "401 UNAUTHORIZED\r\nclientRequestId: f2220082-2402-4aad-b757-47f6fdf1f91c\r\nserviceRequestId: 782ebda0-e00d-6000-b366-ca4a0980c382",
"status": 401,
"source": "https://haufegroup.sharepoint.com/sites/CLEVISHPOPs/%2FShared%20Documents%2FKundenprojekte%2F00_Austausch%2FVertraege%2FPER-007649%2F%C3%84nderung%20Ausbildungsverh%C3%A4ltnis_0f573474-e1dc-4e96-b217-9a974b88f993.PDF",
"errors": []

Was this reply helpful? Yes No