Approvals Error

[JhonaOB1993]

Buenos días chicos 
¿Podrían ayudarme a corregir el siguiente error?

Sucede que me gustaría adjuntar todos los archivos que subes mediante Formularios y enviarlo por correo para aprobar o rechazar, según el criterio del usuario evaluador.

Por ahora, el detalle es que al generar la solicitud de aprobación y adjuntar los documentos me sale el siguiente error:


Solicitud fallida. Código de error: "InvalidRequestContent". Mensaje de error: "El contenido de la solicitud no era válido y no se pudo deserializar: 'No se pudo encontrar el miembro' ContentBytes 'en el objeto de tipo' ApprovalsConnectorAttachment '. Ruta' adjuntos [0] .ContentBytes ', línea 1 , posición 559. ' . ". 

Cabe mencionar que el flujo no genera error al guardarlo



Saludos,

Jhonatan Ora Badillo

[Tom_Slosse]

Hey @JhonaOB1993 

Could you please translate your question to English.

You will have more people to be able to understand your question.

Kind regards

Tom

[manuelstgomes]

Hi @JhonaOB1993 

@Tom_Slosse  is right. (Google Translate) Debe enviarlo en inglés, de lo contrario, la gente no podrá ayudarlo.

Translating the question:

Good morning guys
Could you help me correct the following error?

It happens that I would like to attach all the files that you upload using Forms and send it by mail to approve or reject, according to the criterion of the evaluating user.

For now, the detail is that when generating the approval request and attaching the documents I get the following error:


Request failed. Error code: "InvalidRequestContent". Error message: "The content of the request was invalid and could not be deserialized: 'Could not find member' ContentBytes' in object of type 'ApprovalsConnectorAttachment'. Path 'attachments [0] .ContentBytes', line 1 , position 559. '. ".

It is worth mentioning that the flow does not generate an error when saving it



Regards,

Jhonatan Ora Badillo

The approval Power Automate expects something like this:

[
  {
    "name": "file 1 name",
    "content": "file 1 content"
  },
{
    "name": "file 2 name",
    "content": "file 2 content"
  }
]

You have to do the following:

1. Create a string variable
2. For each attachment
3. Get the file contents and name
4. Append to the array:

{
    "name": "file 1 name",
    "content": "file 1 content"
  }

Add this to your approval, Power Automate.

Can you please check if and let me know if you have any questions?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[CFernandes]

@JhonaOB1993 I am 99% sure that @manuelstgomes reply will resolve your problem but if it does not then please share the screenshot of your Flow with the Approval action expanded in the Edit mode.

[JhonaOB1993]

Good morning, dear.
I attach the screenshots of the flow.

Please could you help me with a solution? Now I get the following error

BadRequest. Request failed. Error code: "AttachmentContentNotValidBase64String". Error message: "The content of the attachment" imgAvInBev_anonymous.png "is not a valid Base64 encoded string."

Regards,

Jhonatan Ora Badillo

 

[CFernandes · Accepted solution]

@JhonaOB1993 Can you please decorate the FileContent with the base64() function(screenshot below).

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JhonaOB1993]

@CFernandes thanks a lot for your answer.
Could you help me with following question, please?
It happens that now you are sending an email to approve for each file (Ideally, you should send everything in a single email, since users could attach up to 3 files as support).
Also, when sending the email to notify if it was approved or rejected, it generates the following error.


In condition: ActionFailed. Action error. No dependent action was successful.
On Email: OpenApiOperationParameterValidationFailed. The "inputs.parameters" element of the workflow operation "Send_Email_ (V2)" of type "OpenApiConnection" is not valid. Error details: Required property "emailMessage / Attachments / 0 / ContentBytes" is missing in the "SendEmailV2" API operation.

[CFernandes]

@JhonaOB1993 Are you using an 'SendEmailV2' action in your Power Automate? Can you end me a screenshot of it. 

[JhonaOB1993]

Of course :)

The error that is generating me is the following:

The "inputs.parameters" element of the workflow operation "Send_Email_ (V2) _3" of type "OpenApiConnection" is not valid. Error details: The required property "emailMessage / Attachments / 0 / ContentBytes" is missing from the "SendEmailV2" API operation.

I would like the flow, then approve or reject, to attach all these files and email them to the requester and get the result with the approving user's comment.

In this case, I am testing with a .PNG file

Thank you!

[CFernandes · Accepted solution]

@JhonaOB1993 I think I understand your problem.

As you already know, the Approval action accepts attachment array in Format

But Send an email accepts an 'Contentbytes'.

{
"Name": @{items('Apply_to_each')?['DisplayName']},
"ContentBytes": @{body('Get_file_content')?['body']}
}

and then pass it to the Send an Email action.

Now that being said,  it seems that you stumbled over a known bug. You would need to manage this in your Power Automate. 

I hope this helps.

[JhonaOB1993]

Thank you very much!!!! I see that it does attach the files and send the mail :)
Just one last inquiry, please.
Do you know why I refused the shipment to the recipient?
In this case, the users requesting approval are external and I see that they handle .gmail .hotmail domains or others.

Thank you!

[CFernandes]

@JhonaOB1993 The error is not related to Power Automate 🙂 The Error you are getting  "Your message was not delivered because the recipient's email provider rejected it"

That's the default message you get when the sender's IP is blocked. Which should not happen if the sender is O365.

You might want to contact your Office 365 Exchange Administrator(your IT guy), he should provide you more insight into this problem.

I hope this helps.

[JhonaOB1993]

Thanks for the info :)
Please, could you indicate the link, email or telephone number to contact me.
I would like to have the flow ready today :)

Thank you very much!!!

[CFernandes]

@JhonaOB1993 Please open a Ticket with Office 365 support. You can open a ticket with Office 365 support by calling them directly or by creating a support Ticket from your Office 365 portal.

For more details see: https://docs.microsoft.com/en-us/microsoft-365/admin/contact-support-for-business-products?view=o365...

[Gisela068]

Hola,

Estoy construyendo un flujo de aprobación a partir de un formulario en forms con adjuntos que primero va y almacena los archivos en Sharepoint y luego dispara un flujo de Aprobación. Cuando ejecuto el flujo corre bien hasta que llega a la aprobación donde me sale el siguiente error:

Error de la solicitud. Código de error: "AttachmentContentNotValidBase64String". Mensaje de error: "El contenido del archivo adjunto "RAA OCTUBRE 2020_Gisela Tamayo 1.pdf" no es una cadena válida codificada en Base64.".

He creado la variable y anexado a la matriz con "content" pero no funciona.

{
"Name": "@{items('Aplicar_a_cada_uno')['name']}",
"content": @{body('Obtener_contenido_de_archivo_mediante_ruta_de_acceso')?['body']}
}

Agradezco su ayuda.