Automatically extract company name from excel and add accountID and industry and add them into excel

[Mark-JZ-Yeap]

A user will upload a certain list of companies in an excel on a sharepoint/onedrive.

I need extract those company names from the excel and then search those company names one by one in Account table.

If I find the company name, I will add the AccountID and industry of the matching company.

I will add these 3 columns in another excel and then paste this excel in the same sharepoint/onedrive.

All this needs to be automated, except the part where user uploads a excel, that will be automated.

Please assist and show me the steps.

[v-csrikanth]

Hi @Mark-JZ-Yeap 
If you seeking guidance on the Power Automate Forum.
https://community.powerplatform.com/?redirectedFrom=https://community.powerplatform.com/t5/Microsoft...

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[lbendlin]

Power BI is (mostly) read-only. It certainly isn't capable of writing back to Excel files (as of today).  You will have better luck on the Power Automate forums.

[Mark-JZ-Yeap]

It's best to use power automate.