Power Platform Community Forum Thread Details

I am trying to get Power Automate to send an email if a UBI report (error report) has any results.

For example: there is a report built to let us know if a certain field is blank. Normally the report is empty (meaning output file has only header and no subsequent lines). Therefore, there should be an email sent when the report contains at least one line (not including the header).

Previous in OBI there was a default condition: "ConditionROWCOUNT('ReportName') > 0
However in Power Automate there is no "RowCount" as a condition.

I have tried using "Length" but this gives me an error message: The error indicates that the 'length' function is receiving a null value instead of an array or string. This issue arises because the flow is trying to access the 'value' parameter from the output of the 'Move file' operation, which may not exist or is returning null. Did you check if the 'Move file' operation is successfully returning a valid output, particularly the 'body' and 'value' parameters?

Length formula: length(outputs('Move_file')?['body/value'])

(move file is in reference to the previous step in the flow)

I have also tried "Empty": empty(body('Export_To_File_for_Paginated_Reports'))

I have also tried using the output file size (as when there are results the file has more rows and is therefore larger in size) but this is so far been unreliable.

What is the best/simplest formula that Power Automate can check if there is at least 1 row (not including the header)?

Categories:

Building flows