Forum Discussion
Helper IIIDynamic Report Subscription
Under "Map my data" can you uncheck the "pre-existing filter option?
Hope you have read my article, I explained the RLS scenario there. Techically how dynamic subscriptions work in your scenario is, it will iterate over the list the list of email ids you selected and then applies the filter (which is email id column) and then sends one email for ever row.
Which is exactly what you are expecting, Since you have hardcoded your email in the "send to" section you got those many emails as many as the # of emails you have in the column you selected.In an ideal scenario, when you map email id column to the "Send to" section, you will not be able to choose the same the column in the "Report Filters" section as I have shown you in my previous response. So I created a duplicate column of my email id column and mapped the filters in this way
"Duplicate Email ID" = "Original Email ID"
So, these are my suggestions:
1. Uncheck the "Pre-existing" filters
(test the scubcription, I guess this should solve the blank visuls issue)
2. Create a duplicate email id column in your RLS table and and put the filter on it in "Report filters" section.
As I have mentioned in my article, this approach worked for me with out any issueHope this helps
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Helper IIIThanks for the response! This is how i have it set up but I am getting the same result. Blank table and multiple emails.
i selected the dataset for connect to recipient data. This is the same dataset the report is connected to.
for select and filter data, i chose the email column of my user table. In the report, filtering on this column will give you MS Dynamics data for that user:
Email details. I just have myself as the recipient for my testing
Map your data. I am able to choose the same internalemailaddress field for both and have include my changes enabled.
Helper IIItharunkumarRTK could it be because my RLS allows me to see all data? Is there a way to have it be just the ones where my email matches?
- tharunkumarRTK
Super User
Under "Map my data" can you uncheck the "pre-existing filter option?
Hope you have read my article, I explained the RLS scenario there. Techically how dynamic subscriptions work in your scenario is, it will iterate over the list the list of email ids you selected and then applies the filter (which is email id column) and then sends one email for ever row.
Which is exactly what you are expecting, Since you have hardcoded your email in the "send to" section you got those many emails as many as the # of emails you have in the column you selected.In an ideal scenario, when you map email id column to the "Send to" section, you will not be able to choose the same the column in the "Report Filters" section as I have shown you in my previous response. So I created a duplicate column of my email id column and mapped the filters in this way
"Duplicate Email ID" = "Original Email ID"
So, these are my suggestions:
1. Uncheck the "Pre-existing" filters
(test the scubcription, I guess this should solve the blank visuls issue)
2. Create a duplicate email id column in your RLS table and and put the filter on it in "Report filters" section.
As I have mentioned in my article, this approach worked for me with out any issueHope this helps
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!