Question

Is it possible to read and check if there is no data in the excel document inside a microflow?

0

Hi All, I have an issue where we are creating an excel document inside a microflow, but in some cases there are no records inside the excel that was created. Is there any way to read the excel and check if there are empty records in it?

asked 2021-03-10

Akash Casula

2 answers

Ronald Catersels · Answer 1 · 2021-03-10

If you create the Excel sheet yourself would it not be wise to do a retrieve first of the objects you are putting in the Excel template and if no records can be found skip the creation part?

Otherwise create a Java action that checks the metadata of the Excel.

Regards,

Ronald

Thijs van der Meer · Answer 2 · 2021-03-11

Not really sure what’s going on internally, but technically you can create an import template using the “excel importer” module from the marketplace, and check if this contains objects?