3,888 questions
Is there another way to convert JSON downloaded from Form Recognizer Studio to Excel? Issue: Missing menu button on Power Automate.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 61%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Josh Goh
0
Reputation points
My main goal was to use Form Recognizer Studio to scan documents and convert them into excel will all the contents in its proper fields. My current result is all contents end up in one field.
I contacted Help + Support and was instructed to follow this tutorial.
Link: https://learn.microsoft.com/en-us/azure/cognitive-services/language-service/named-entity-recognition/tutorials/extract-excel-information
I was stuck at the part where I had to select the language connection.
To find the list of available connections, I was instructed to follow these steps:
- Open your flow in Power Automate.
- In the top-right corner, select the
...menu and then selectConnections. - In the
Connectionspane, you will see a list of available connections.
I was unable to find the 3 dot menu button.
Attached are screenshots showing there is no 3 dot menu button on the top-right corner.
Microsoft 365 and Office Excel For business Windows
Azure AI Document Intelligence
Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
2,100 questions
{count} votes
-
romungi-MSFT 48,906 Reputation points Microsoft Employee Moderator2023-05-29T14:50:34.6866667+00:00 @Josh Goh I think the suggestion to use language studio connection to convert a JSON to excel seems odd as the document referred can be used to extract NER from your excel document in a separate column using the mentioned connector. For your goal to convert JSON to excel I think you will have to write a excel utility to extract the fields that are required to convert to an excel table. There is a sample in the form recognizer python SDK repo to convert JSON to dict which can be useful to use the dict and then save it as csv file and use excel to convert to excel format. I hope this helps!!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
David S 0 Reputation points2023-05-29T18:38:46.9333333+00:00 If you're experiencing issues with a missing menu button on Power Automate for converting JSON downloaded from Form Recognizer Studio to Excel, there are alternative methods you can try to accomplish the task. Here's one possible approach:
Save the JSON data downloaded from Form Recognizer Studio to a local file on your computer.
Use a programming language or tool that supports JSON parsing and Excel manipulation, such as Python with the Pandas and openpyxl libraries.
Write a script or code to read the JSON data from the file and convert it into a suitable format for Excel. You can use the JSON library in Python to parse the JSON data into a structured format.
Once you have the data in a suitable format, use the Pandas library in Python to create a DataFrame, which is a tabular data structure that can be easily exported to Excel.
Finally, use the openpyxl library in Python to export the DataFrame to an Excel file. This library provides functionality to create and manipulate Excel files programmatically.
By following these steps, you can convert the JSON data downloaded from Form Recognizer Studio to an Excel file without relying on the menu button in Power Automate.
Sign in to comment
Sign in to answer