Hi,
We are trying to read phone call activity data using the following service:
Even when we grant Read permissions at the BU level to the Phone Call entity, we still cannot read the Phone Call records from the msdyncrm_phonecallactivity table.
Does access to msdyncrm_phonecallactivity come from Dynamics or a completely different set of access roles?
Thank you,
Tony
Even though dbo.phonecalls was not in the SSMS, we queried this exact table and it came back with the data we want. Your response made us try that query. Thank you!
SELECT TOP 10 * FROM dbo.phonecalls
Hi Tony,
If you’re going to access the data of Phone Calls, which you need is the phonecall entity instead of the msdyncrm_phonecallactivity.
The data of the entity can be transformed normally.
If you have further problem about it, it is recommended to post your issue to the forum of Power Virtual Agents for more help.
Here is the link:
https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1
If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.
Best Regards,
Nya
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156