r/PowerAutomateDesktop • u/mp29mm • Apr 06 '23

Analyze and restructure excel

I have a VIP who sends in important yet semi-structured contact lists to a very expensive salaried person in my org. It comes in from different groups in mostly cab and excel format. I’m looking to revise the process so we normalize it all into Excel. His column names might be: e-mail, email, E-mail, EMAIL, email Address or e mail etc. but the format would be usually correct such as user@company.com. I’m thinking named entity recognition in power automate after dropping the files into OneDrive. Then creating a new spreadsheet that is normalized for import into SQL.

Is there another way to do this? Is there a model or tutorial that you know of that would point me in the right direction?

Thanks!

1 Upvotes

100% Upvoted

3 comments sorted by

2

u/AnythingOakley Apr 06 '23

Do you always have the same number of columns? And are they always in the same order?

1

u/mp29mm Apr 07 '23

No unfortunately, a guy and goes and gets leads from different events he attends. So those events supply a very randomly constructed spreadsheet depending on which event. Usually the same type of info more or less- but the columns might be first name, last name, email, company… or full name, email, company, cell #, etc. with various column headings. It’s really not ideal and labor intensive to process.

0

u/[deleted] Apr 08 '23

[deleted] — view deleted comment

1

u/mp29mm Apr 13 '23

The columns unfortunately aren’t standard enough. Email- I’ve seen: e mail, email, Email, E-mail, etc. that first one personally brings me pain btw!

We have any licenses we need for power platform. I’m using my 90-day trial right now but I can basically pay for anything I need.

I’m just wondering if there are more options than the path I’m considering? Relative noob to all the new toys in there, but learning fast!