Unanswered

Base64toString Not Working For Me

(0) Share

Report

Posted on by m_williamson

Hi all,

I am trying to build a flow that converts a CSV file into an xlsx file using a guide, but my Flows continue to fail at the step after the base64ToString conversion. As you can see below, the conversion is not correctly transforming and I cannot figure out why.

The concerned section of my flow looks like this:

Is there something wrong with my syntax? My base64 looks like below:

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
You base64 decodes fine. What happens if you just put in a compose with the file content (without decoding it).
filedAt,Industry_Group,Asset_Class,url,cik,Minimum_Investment,Inception_Date,fund_name,fund_zip_code 2020-11-23T17:16:46-05:00,Residential,Private Capital,https://www.sec.gov/Archives/edgar/data/1824551/000182455120000001/xslFormDX01/primary_doc.xml,1824551,"25,000",2020-11-19,"Northbrook ND Investments, LLC",55402 2020-11-23T17:10:04-05:00,Other Real Estate,Private Capital,https://www.sec.gov/Archives/edgar/data/1833435/000183343520000001/xslFormDX01/primary_doc.xml,1833435,"50,000",,CCG SMALL PROPERTY FUND II LLC,98004

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

Hey@m_williamson @Paulie78

You need to be careful using a base64 string in a variable... in some scenarios, Flow will silently re-encode the string when you try to use this in another action.... and you can't see this in the run history, thus onward actions fail as they have received a corrupt base64 string.

What are you doing with the variable onward in your flow?

FYI - The Encodian 'Convert Excel' covers this (Convert CSV to XLSX) - see https://blog.encodian.com/2020/09/convert-excel-and-csv-files-in-power-automate/#2

Was this reply helpful? Yes No
m_williamson 17 on at

Like (0)

Report
Copy link

Link copied!
Hi both,

When I try chucking the base64 in a Compose, it all seems to work (but I get an error later on to do with the fact it's in an Array and it expects a JSON or XML):
Unable to process template language expressions in action 'Filter_array' inputs at line '1' and column '27756': 'The template language function 'json' expects its parameter to be a string or an XML. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#json for usage details.'.

But I need this to be dynamic, how do I fix the problem with reference to this case.

Later in my flow, I am trying to follow the process in the guide: https://sharepains.com/2020/03/09/read-csv-files-from-sharepoint/ which looks something like:
Basically I just want to make an Excel table out of the CSV output, why is this so hard and why doesn't Power Automate support CSV formats?

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

Hi @m_williamson

The Power Platform can't cover every use case, that's why there are custom connectors, extensibility points and a partner ecosystem to help plug the gaps / build solutions. There always user voice to post new features requests and the PA forum for feature requests... i.e. if enough people vote for a feature it will be prioritized.

It'd be helpful to understand which action is throwing the error and the data from your run history.

Or try a third party 'Parse CSV' action, Plumsail and Encodian provide a 'Parse CSV' action - check out this video for guidance (from 3:40): https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Add-CSV-Data-to-a-SharePoint-List-with-Power-Automate/td-p/744269

HTH

Jay

Was this reply helpful? Yes No