
Announcements
Hi all,
I'm wanting to schedule everyday a stock on hand download from Microsoft Business Central, and then save this extract into SharePoint with the extracted day's date.
I have the re-occurrence setup, and the table from Business Central, but I seem to get two issues;
1) Extracted file format - this is in a file format that is not txt or excel.
2) Multiple files in SharePoint
Not sure if I'm missing a step to convert it into an xlsx? Or if it's a MS license issue?
Dear A,
It looks like the the output of the action 'Find records' is an array. You cannot directly use an output array to create a file with. If this is really the data you are looking for, suggest you store the array data in an excel onedrive file or a sharepoint list.
Since it seems you are unfamiliar with an array, suggest you read up on some forums/videos on how to save an array into an excel/sharepoint list (too long to explain here, but not difficult).
Happy flowing,
Koen