I have built a Pivot table and after refreshing it (since source data changes), I would like to send the pivot table in an email. I do see couple of posts regarding this topic. How do I do that? If you have a final version of the work flow could you please share?
Hi @Palaniyappan, Thank you for the detailed steps. I am having issues with the Get Table Range block using string variables. Could you please forward me a copy of the workflow of Get Table Range activity.
@Palaniyappan But before reading and sending it to email , How to manage pivot table fields when pivot table is created using Create Pivot Table …
say example …
Read Range activity
Create Table activity
Create Pivot table activity
When I see my Excel sheet , in pivot fields all columns will be under Row category … I do not need that …I need to manipulate pivot fields like move one column to Column label , other into filters like that … How to achieve that , please can you suggest me