FLow Error from Powerapps Merging Excel template

Hi there,

I am having this error:

error": {
"code": "Plumsail.Actions.Api.DTO.Exceptions.DataValidationException",
"message": "The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. ",

Someone could provide some help?

Thank you kindly

Hello, @sajarac

Try to use base64() expression in the Documents action field to process the file content data you want to use. I don't know which exactly action you use so I got the "Compose" action for example (don't pay attention to other actions).

Pass to the function dynamic content that should be processed:

Hi there, thanks again for your response, sorry, if this is my flow structure that's mean that I have to add a new step after the powerapps trigger?

Hello @sajarac

You need to select the base64 function in the Documents action field. I don't see the Documents action in the screenshot, but I suspect it's in the Apply to each section, isn't it? Please share a screenshot in Edit mode.

Best regards,
Petr Bushuev
Plumsail team

Here is the screen shot but I can not get the dynamic content pass to my excel file

Hello @sajarac,

Actually document content file should have raw content of the source .xlsx template file. usually it's extracted from other connectors like: SharePoint, OneDrive, etc

I'd recommend you placing the xlsx template to OneDrive, use Get file OneDrive action and select the Get file result in Plumsail action Document content field

Also please check out the example

Best regards,
Petr Bushuev
Plumsail team

Sorry bud, this is getting more confusing.

I just did your suggestion

Hello @sajarac

I store a xslx file in the OneDrive folder in the example. You need to provide an xslx template to the Convert action. Where do you keep the template?

Best regards,
Petr Bushuev
Plumsail team