I have a flow that runs three queries against a Power BI dataset and formats the output as HTML tables that then go into an email (so each email has three separate tables - each table basically refers to different 'due date' ranges of tasks). The flow runs fine and outputs the table as expected... when there is matching data. If there is no data that matches the criteria in the query, the users get an email with a placeholder with a border. So, yes, it is returning no data, but it looks a bit weird and also may look to the user that the task has failed to generate the table properly. I am trying to find a way to either return just the header row of the table or some alternate text e.g. 'No relevant data', so the user specifically knows that there are no tasks for them to deal with. This is the current outline of the flow.
I've tried adding conditions and I have seen mention of variables, but this is beyond my current knowledge in Power Automate (I rarely use - I am a Power BI man). Does anyone have any ideas?
Share
Report
All responses (
Answers (
525
