cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartSil
Frequent Visitor

Power Automate JSON encryption

I'm trying to send a PowerApps collection via email in an encrypted fashion.

So, my idea was to pass the collection as a JSON to a Flow putting the received JSON into a Compose action and then using the Azure connector called "Encrypt data with key", in order to encrypt the JSON (in the Compose action) using a key I have created in an Azure Vault.

Problem is that the "Raw data" parameter of this connector will accept only simple text and not JSON.

The error says:

"Operation failed because some of the inputs are not valid."

So, is there a way to "Flatten" a JSON to become simple text? 

Any other ideas?

 

02.png

 

01.png

 

 

1 REPLY 1
Sundeep_Malik
Memorable Member
Memorable Member

Hey @MartSil 

You can use parse JSON to do this.

First take parse JSON action. 

Pass get ships doc output in it. 

Then copy the output you are getting the get ships doc and add it to the generate from sample.

 

After this use select function.

Or 

If you want each value individually, you can just directly use the fields you are getting from parse JSON.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,072)