Power Platform Community Forum Thread Details

Hi all!

I'm trying to:

Create a Form - Done
Upload an excel file to the Form - Done
Read a Table from the Excel (it is in the second Sheet but its the only table)
Put the information from the Table to a List in SharePoint - The list is created

What I did was (sorry for the terms but my PowerAutomate is in spanish):

When you get a response (trigger)
Get details from answer
Analysis from JSON file
- Here I've put the field from the form where I upload the Excel
- I got the name, link (URL), ID, size, etc etc
Get content from file with access address (inside a "For each")- ERROR
- Here I've put the "Link" that I got from the JSON

My error is:

Unauthorized
Error en la acción "Obtener_contenido_de_archivo_mediante_ruta_de_acceso": A potentially dangerous Request.Path value was detected from the client (?).

The headers of the output:

{
"Cache-Control": "no-cache",
"Pragma": "no-cache",
"Transfer-Encoding": "chunked",
"x-ms-request-id": "ad8711be-21d6-4f53-a859-9791822e01c7",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"x-ms-client-region": "japan",
"x-ms-flavor": "Production",
"X-Ms-Workflow-Resourcegroup-Name": "0A10C040A36642A498F40E9BD058D2DD-DEFAULT0A10C040A36642A498F40E9BD058D2DD-ENV",
"x-ms-workflow-subscription-id": "8d2b76b4-59d0-4174-9121-88362f9aeb36",
"x-ms-environment-id": "default-0a10c040-a366-42a4-98f4-0e9bd058d2dd",
"x-ms-tenant-id": "0a10c040-a366-42a4-98f4-0e9bd058d2dd",
"x-ms-dlp-re": "-|-",
"x-ms-dlp-gu": "-|-",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Tue, 19 Nov 2024 09:45:38 GMT",
"Content-Type": "application/json",
"Content-Length": "153",
"Expires": "-1"
}

The body of the output:

{
"status": 401,
"message": "A potentially dangerous Request.Path value was detected from the client (?).",
"source": "api.connectorp.svc.ms"
}

Other data:

Name of the form: New Application Form (mandatory)
The form only ask you for a code (I put a number) and only one Excel file to upload (mandatory)
Name of the Excel file that I've uploaded: NewTemplate - Solo before.xlsx
Name of the Excel inside my OneDrive: NewTemplate - Solo before_MyFirstName LastName.xlsx
Some of the caracters inside the Excel file are in Japanese

What I've tried:

Get driveItem - I tried an HTTP for Azure, didn't work
Get HTTP using Microsoft Graph https://learn.microsoft.com/en-us/graph/api/driveitem-put-content?view=graph-rest-1.0&tabs=http#request-body and https://developer.microsoft.com/en-us/graph/graph-explorer, didn't work as well
I was trying everything. I even copied the Excel to a new file but it gave me an error about extention/format

I do not have the premium access. I'm using my company's Office 365 but they have the basic one.

Im not really good at Power Automate, so if someone could help me explaining to me as a child I will appreciate it a lot!

Best regards from a peruvian in Japan.

Categories:

Building flows