Unanswered

Multiple Attachments to an Approval works for a couple of days then starts to fail

(0) Share

Report

Posted on by rmccann810

I have created and Approval flow that incorporates multiple attachments in an array that are then attached to an approval. When the flow is first created, it works fine for a day or so and then starts to return the following error:

BadRequest. The request failed. Error code: 'AttachmentContentNotValidBase64String'. Error Message: 'The content for attachment 'Form Template_TAS Automation.xlsx' is not a valid base64 encoded string.'.

The attachments are converted with a Parse JSON and included in the Array using the Get File Content Connector.

Could anyone help with this please.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Hi @rmccann810 ,

Could you share the screenshot of the flow configuration?

Is this problem encountered only when the attachment is Form Template_TAS Automation.xlsx or can any file reproduce the same problem? Please check whether this attachment can be opened normally.

Besides, you could refer to the following thread to get $content in File content and append it to array variable.

https://powerusers.microsoft.com/t5/Building-Flows/Get-attachment-content-and-attach-it-to-a-Start-and-wait-for/m-p/558117

Please provide more details so that we could provide a proper workaround for you.

Best Regards,

Was this reply helpful? Yes No
rmccann810 6 on at

Like (0)

Report

Hi Barry,

I had previously tried to set the flow up using get attachment/get attachment content connectors but the attachments were coming through as corrupted.

Please see below. It has now resolved itself without me having changed anything but another user within our team has also been having an issue with an approval connector with no dynamic content in it stating that the "Required field 'assigned to' contained no valid users in the organisation" which was not the case. Both issues can be resolved by recreating the same steps in a new flow.

Many Thanks,

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @rmccann810 ,

Great, it seems that it is a temporary issue. As for the error that you mentioned "Required field'assigned to' contained no valid users in the organisation", it is because the users in the Assigned to field are not members of the organization. The person who may submit the form is a user outside the organization or the current browser does not have the user's credentials, so this is the response submitted anonymously.

Feel free to let us know if you have any other questions.

Best Regards,

Was this reply helpful? Yes No
Dr_Lee on at

Like (0)

Report

@v-bacao-msft Hi all - so this is also happening to me, and it is really worrying as I am about to launch this robot as a preview of what Power Automate can do in our organization, and I fear this may steer them clear. I am getting the base 64 error for multiple different attachments, but like with @rmccann810 it seems to happen sporadically. It only happens with the Get Attachments - Get Attachment Content - Append to Array - Approval sequence:

Elsewhere in this flow, I append to an array using content from a file metadata and content pull and a JSON call and a OneDrive content pull and that one has yet to give issues. The Sharepoint one is frequently doing this. Any further ideas welcome before I launch this workflow!

Was this reply helpful? Yes No