Share
Report
68Hello,
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
Categories:
I have the same question (0)
All responses (
Answers (
