cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
westman
New Member

Power Automate to create AI builder to extract data from excel document and then output data into another external excel file

Hello-

I am new to power automate and this is my first post about the topic to a forum. My apologies if do not phrase the use case correctly. I have a project that i think can be greatly advanced by power automate and ai builder but i am unsure of the feasability in which i presume to use it.

 

I have hundreds of excel files that have a form template structure on them. I would like to extract data from the fields (cells) within those excel files and save them to an external excel spreadsheet..  Is this possible?

Secondly, i would like to run the process like a batch on all the files. I assume the best options is to have al the files that need process to be saved in a prefetch folder.

I have found information that AI builder can read pdf files and accomplish what i want to do, however, i assume i have to convert my excel files to .pdf to take advantage of the ai builder; or am i over-complicating the process?

Please feel free to post any links to articles or videos that may aid in advancing my project and its undertaking.

 

Thank you for any direction or advisement going forward

D.Westman

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you @plarrue . I will research the links you've given and go from there.

 

View solution in original post

2 REPLIES 2
plarrue
Power Apps
Power Apps

Hi @westman ,

 

You may find this post helpful if you'd like to learn how to extract data from multiple Excel files

https://powerusers.microsoft.com/t5/Building-Flows/Extract-data-from-multiple-excel-files/m-p/152795... 

 

The AI Builder product is also covered in this learning module

https://learn.microsoft.com/training/browse/?products=ai-builder&expanded=power-platform 

 

Please refer to the AI Builder Overview page if you would like to learn more
https://learn.microsoft.com/ai-builder/overview 

 

This Power Automate Cookbook shared by the community lets you import flows into your environment and test them

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/bd-p/MPA_Cookbook 

 

Hope it helps!

Thank you @plarrue . I will research the links you've given and go from there.

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,843)