Dynamic Subscription to sharepoint

[SteveD33]

Is there a way to set up a dynamic subscription but instead of delivering the output by email it saves it to sharepoint?  I can see a normal subscription can send to sharepoint, but you don't have the functionality of filtering the output whereas with dynamic subscription you can filter the output but only have the choice to send to email.  Thanks

[v-xiaocliu-msft · Accepted solution]

Hi @SteveD33 ,

You can create two dynamic subscriptions.

One subscription is sent to each user so that they can see the report data.

The second dynamic subscription is used to send 500 emails to yourself so that the flow can process them and save them to the sharepoint folder.

Sample:

Best Regards,

Wearsky

[JoraCur]

What about the know issue: Known issue - Dynamic subscriptions don't send emails to recipients - Microsoft Fabric | Microsoft L...
Can you still use this solution at the moment?

[JoraCur]

You can use a logic app to read all emails (Get Emails) and save the attached PDF to a sharepoint/teams location (Create File).

[SteveD33]

The use case is as follows:

I have a power BU report displaying stats for 500 different locations (same stats, only th elocation changes).  Using filters you can drill down through the heirarchy of regions to get to the most granular location.  This is useful with dynamic subscriptions as I can email each individual location with their stats.  However, I have been asked to colate all the individual reports together.  This means collating 500+ individual reports somehow.  I could email myself 500 times and then download the attachments to a single folder - not a realistic option.  So what I want is have the filter functionality of the dynamic subscription combined with the conveniance of sending to a sharepoint folder.  Is this possible?

[SaiTejaTalasila]

Hi @SteveD33 ,

If exporting and organizing them is your problem then you can check this -

You can extract all your location names to one Excel file and in power automate import that file and use for each loop and using performance analyser you can get the dax query and your dax should contain location filter  and in power automate use run a query against a dataset inside foreach and pass location column as parameter inside your dax and output you can save to CSV file into your SharePoint and your users can use that data.

I hope it will be helpful.

Thanks,

Sai Teja 

[lbendlin]

The point of dynamic subscriptions is that you can tailor them to the employee.  Putting them back onto a sharepoint will be counterproductive.

[SteveD33]

It's not counter productive if you understand the reason for it.  And it's not an answer to the question asked.

[SaiTejaTalasila]

Hi @SteveD33 ,

Dynamic subscriptions will do the job.Let us know incase if you have specific requirement.

Thanks,

Sai Teja