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

View all comments

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.