Power Platform Community Forum Thread Details

I've had success with using the AI to read html email data to extract delivery names and addresses using AI into JSON format, then put it into a structured table/excel before getting emailed.

I'm now looking to apply that to a broad range of excel files.

1. These files don't always have table structure

2. Columns names and number of them can vary.

What I'm after is advice on how to extract that data from a range of excel files so the AI can analyse it and return it in JSON format as before . From there I can then put it into a table/excel as before.

Has anybody done similar with some success? Any advice on the workflow required and sample flows would be greatly appreciated.

TIA

Categories:

AI Builder

HI @abonsey

You have a couple of options.

Option 1: Use Graph API to read the data

Graph api Calls do not require an Excel Table to read the data, you just need to know what cells to read

Working with Excel in Microsoft Graph - Microsoft Graph v1.0 | Microsoft Learn

Option 2: Use Office Scripts

If you are able to add a script to your file, you can add a script that reads the data. Then use the Execute/Call a script from SharePoint/Onedrive to retrieve the data you want.

How to Get Data From Excel Without a Table in Power Automate - Power Tech Tips

I hope these resolve your request.

If this does answer your question i'd be grateful if you marked as such and maybe a like.

Thanks!