Save output to Excel file as "No Records Found" instead of having only header columns.

[Sarathi_57]

Hello Guys,

I have a scenario where in when there is no output, instead of writing the output excel file with only the column headers, it should just have a note in the cell A1 as "No records found"

I have attached a sample workflow which takes input from a excel file, then filters for data where Age<20. if there is no output matching this criteria, I want the excel output file to have only one cell A1 which states "No Records Found".

Any idea or workaround?

Thanks

Sarathi

[JoshKushner · Accepted solution]

This workflow will unite the response "No records found" with the data and decide to keep or discard the response if there is populated data or not.

Flow:

Results:

Multi-Row Formula:

[Sarathi_57]

Thanks Josh,

That worked fine.

One more quick question.

I know we can write the data alone without headers using a Table and Render tool to save it to a Excel file. But Is there a way that we can write to excel file using a Output tool without having the column headers and having the data only?

[JoshKushner]

A way to 'hack' this result woud be with the 'Select Records' tool or the 'Dynamic Rename' tool.

Select Records:
2+

Dynamic Rename:
Rename Mode: Take Field Names from First Row of Data

[dawnh80]

Great example! I looked for this solution for a user and shared your workflow.