Forum Discussion
Dynamic Subscription to sharepoint
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
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?
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