cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FBaldwin
Level: Power Up

Conversion functions not working

I'm trying to use a conversion function and when I save the flow it gets removed.   It happens with any conversion functions but specifically I'm trying to use:

base64ToString(triggerBody()?['Signature'])

 

But when I save and then go back to the flow it ends  up being just:

triggerBody()?['Signature']

 

 (this is within a simple Initialize variable action)

 

What am I doing wrong?

 

8 REPLIES 8
Community Support Team
Community Support Team

Re: Conversion functions not working

Hi @FBaldwin,

 

Could you please share a screenshot of your flow's configuration?

 

Thanks for your feedback, the issue is confirmed on my side, but it doesn't happen with any conversion functions. My flow's configuration as below:3.JPG

Within Inputs field of Compose action, type the following formula:

base64ToString(body('Get_file_content')?['$content'])

 

But when I save and close my flow, then re-edit it, the flow shows up as below:4.JPGBut when I run my flow, the flow works successfully as below:5.JPG

 

 

I think the base64ToString() function has taken effect, this issue seems to be related to the display issue within Microsoft Flow. Please take a try to run your flow to check if the base64ToString() function has also taken effect on your side.

 

I would post this issue to my product team, if this issue is solved, I would reply here.

 

 

Best regards,

Kris

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FBaldwin
Level: Power Up

Re: Conversion functions not working

I would love to post some pictures but this editor isn't allowing me to add them - so please see them here:

https://community.nintex.com/community/build-your-own/nintex-for-office-365/blog/2018/03/09/how-to-u...

 

Anyhow my base64 has not taken effect.

Shee_Hao
Level: Powered On

Re: Conversion functions not working

Hi  @v-xida-msft,

 

I will try the approach share by you.

 

hi @FBaldwin

 

you mentioned has not taken effect . Does it mean the problem still exist?

 

Regards,

Shee Hao

Shee_Hao
Level: Powered On

Re: Conversion functions not working

Hi @v-xida-msft,

 

I tested still have the same issue. The error message as below:-

 

BadGateway.

 

Error : The field 'documentbody' contains one or more invalid characters.

 

link to see the content of input : https://prod-30.southeastasia.logic.azure.com/workflows/f8fe1ca488964d3a8f1b248f05f922ab/runs/085867...

 

Currently i configure the flow to read from SQL database and convert the Varbinary type content data to Based64ToString to store the content of document to CRM you can see below screenshot of the flow:

 

flow.png

 

Still not working for my side. Any alternative solution can share to me how to create annotation to CRM? when the data store in Client SQL is Varbinary type.

 

Regards,

Shee Hao

FBaldwin
Level: Power Up

Re: Conversion functions not working

Yes the problem still exists

FBaldwin
Level: Power Up

Re: Conversion functions not working

I don't think your error/issue is the same as mine.  I don't have a badFateway or anything and please note that if I copy and paste the Signature text into a tool like http://freeonlinetools24.com/base64-image   it decodes without issue

Shee_Hao
Level: Powered On

Re: Conversion functions not working

Hi @FBaldwin

 

Yes. I tested by using tool to convert my Varbinary data and copy paste to the Microsoft flow. No error occur and it works. So now i am not sure where is the problem occur. As i know from SDK CRM document content type will work if accept Based64ToString.

 

Regards,

Shee Hao

Shee_Hao
Level: Powered On

Re: Conversion functions not working

Hi @v-xida-msft and @FBaldwin

 

Thanks for the help. I have tested again. I found out 1 thing.

 

The based64tostring expression actually is working for my side only UI issue. But the convertion only able to convert file content of document example like Text (tested by me) it work and able to be created in CRM. But once created unable to download in CRM. This issue i am not sure why because it will show exception in XML format. picture below:-

 

Success created via Flow

Success upload.png

 

Error when download it from CRM

XML ERROR.png

 

Then i upload picture into database and use microsoft flow to push the picture to CRM annotation will have problem said the document body contains invalid characters. Picture below:

 

error invalid.png

 

Hope all this information can help you all.

 

Regards,

Shee Hao

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 66 members 4,531 guests
Please welcome our newest community members: