Power Platform Community Forum Thread Details

Hello,

I have a JSON file in my One Drive where I store all the information from a given process and, until last week, I used to retrieve all the information in a single batch, create the JSON file and replace the previous file in One Drive.

However, the information volume got too big and I started receiving timeout erros in these requests.

To avoid this problem, I want to create a json information for each finishing process and append thais information inside the file stored in One Drive

I tried using "Get File content" from One Drive but insted of receiving the JSON, I receive an unreadable base64 information. I tried using @JSON or eventu 64baseToString but I got an erros message in both cases:

Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '1939': 'The template language expression 'body('Get_file_content')['body']['$content']' cannot be evaluated because property 'body' doesn't exist. Property selection is not supported on content of type 'application/octet-stream'. Please see https://aka.ms/logicexpressions for usage details.'.

Is there a way to decode that 64base information to a JSON or even merge two json files?

Best regards,

Categories:

General topics

Hi @HeFur,

The function to append json information in a JSON File in One Drive or decode the 64base information to a JSON or even merge two json files is not supported in microsoft flow currently.

I afraid that there is no way to achieve your needs in Microsoft Flow currently.

If you would like this feature to append json information in a JSON File in One Drive or decode the 64base information to a JSON or even merge two json files to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.