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.
@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!
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,
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,
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.
Please provide more details so that we could provide a proper workaround for you.
Best Regards,
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional