Skip to main content
Community site session details

Community site session details

Session Id : uLrzzKDUPakX7pVJfoTbAw
Power Automate - Using Flows
Unanswered

How to Not send out attachment in an email when there is no data in the paginated report.

Like (0) ShareShare
ReportReport
Posted on 26 Jan 2023 16:48:01 by 6

Hi,

We have requirement for our paginated reports power automate flow --> If there is no Data in the report we are not supposed to send out the empty attachment in the email. Is there any function we can use for this  requirement? 

 

We have that option in SAP Business objects, but I cant seems to find the option in PowerBI/Power Automate.

  • jiwhite Profile Picture
    498 on 26 Jan 2023 at 23:14:26
    Re: How to Not send out attachment in an email when there is no data in the paginated report.

    Post a screenshot of your flow with identifying information blacked out for a recommendation on how to check in the flow.

  • usman1158 Profile Picture
    6 on 26 Jan 2023 at 22:49:06
    Re: How to Not send out attachment in an email when there is no data in the paginated report.

    for this query below, i just need to add a where clause  sender_id = 77110, how do we add where clause n DAX ?

     

    // DAX Query
    DEFINE
    VAR __DS0Core =
    SUMMARIZE(
    'Query1',
    'Query1'[dest_id],
    'Query1'[edi_file],
    'Query1'[file_name],
    'Query1'[insert_dt],
    'Query1'[notes],
    'Query1'[receiver_id],
    'Query1'[ref_id],
    'Query1'[sender_id],
    'Query1'[status_ind],
    'Query1'[sum],
    'Query1'[tracking_id],
    'Query1'[trans_type],
    'Query1'[task_count]
    )

    VAR __DS0PrimaryWindowed =
    TOPN(
    501,
    __DS0Core,
    'Query1'[dest_id],
    1,
    'Query1'[edi_file],
    1,
    'Query1'[file_name],
    1,
    'Query1'[insert_dt],
    1,
    'Query1'[notes],
    1,
    'Query1'[receiver_id],
    1,
    'Query1'[ref_id],
    1,
    'Query1'[sender_id],
    1,
    'Query1'[status_ind],
    1,
    'Query1'[sum],
    1,
    'Query1'[tracking_id],
    1,
    'Query1'[trans_type],
    1,
    'Query1'[task_count],
    1
    )

    EVALUATE
    __DS0PrimaryWindowed

    ORDER BY
    'Query1'[dest_id],
    'Query1'[edi_file],
    'Query1'[file_name],
    'Query1'[insert_dt],
    'Query1'[notes],
    'Query1'[receiver_id],
    'Query1'[ref_id],
    'Query1'[sender_id],
    'Query1'[status_ind],
    'Query1'[sum],
    'Query1'[tracking_id],
    'Query1'[trans_type],
    'Query1'[task_count]

  • usman1158 Profile Picture
    6 on 26 Jan 2023 at 22:46:04
    Re: How to Not send out attachment in an email when there is no data in the paginated report.

    we basically have Prompts in the report and those prompts kind of work after the report has fetched all the data.

    So we open the paginated report on Workspace, and it brings al the data, and we select the prompts( parameters) and then the related data shows up. Now in the option of showing Null in the flow, we do have that option, but then it only shows the DAX query without the parameter, so basically it will look for the NULL data for the entire data and not for the ones specified in the report.

    So question, we have a DAX query in the Flows, is it possible how to add the parameter selected value in the DAX query ? I have not worked with DAX query before, so wanted to understand how to add the where clause of that paramter in the dax itself 

  • usman1158 Profile Picture
    6 on 26 Jan 2023 at 21:47:39
    Re: How to Not send out attachment in an email when there is no data in the paginated report.

    how do we check that ? is it possible we can check that in Power Automate flow itself ?

  • jiwhite Profile Picture
    498 on 26 Jan 2023 at 21:45:31
    Re: How to Not send out attachment in an email when there is no data in the paginated report.

    Have you tried checking whether the content of the report is null or its length before emailing?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete