Unanswered

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

(0) Share

Report

Posted on by usman1158

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.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

jiwhite 500 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
usman1158 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
usman1158 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
usman1158 6 on at

Like (0)

Report
Copy link

Link copied!

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]

Was this reply helpful? Yes No
jiwhite 500 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No