Read an excel file uploaded in One Drive via Power Automate and Upsert data in Business Central table

(0) Share

Report

Posted on by Inkey Solutions

2,100

Hi all,

I have a requirement where I have to read an uploaded excel file in One Drive and insert data into Business Central using Power Automate MS flow. I have found "Excel Online (One Drive )" connector but having some limitations as the file could be more than 10 to 15 MB and we do not have a "Table" in an excel file.

Could anyone help me with this?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

You may need to throw RPA into the mix to convert the excel file and save a new version first. Excel connector has a preference to a table based format.

Was this reply helpful? Yes No