Import file into Business Central from Power automate

(1) Share

Report

Posted on by CU17041118-0

Hello,

I have a procedure that creates multiple purchase orders from an excel file

But now i want that this process be done automatically through power automate, without any intervention from the user to click at a button or something

I want to run it automatically when a file is created in one drive

Is there any solution to do it ?

How to get the file and pass it to the procedure

Even though i'm passing the excel file in the previous version the standard way like this :

UploadIntoStream(UploadExcelMsg, '', '', FromFile, IStream);
        FileName := FileMgt.GetFileName(FromFile);
        SheetName := TempExcelBuffer.SelectSheetsNameStream(IStream);
        TempExcelBuffer.Reset();
        TempExcelBuffer.DeleteAll();
        TempExcelBuffer.OpenBookStream(IStream, SheetName);
        TempExcelBuffer.ReadSheet();
        TempExcelBuffer.SetFilter("Row No.", '>1');
        if TempExcelBuffer.FindSet() then begin
 
 