filter(Microsoft.Dynamics.CRM.Today(PropertyName='createdon'))/groupby((createdby/fullname),aggregate($count as activity_count))
I am getting an error "Systemuser doesn't contain an attribute name ownerid". I am not using ownerid. Any suggestions would be appreciated.
Hi @Anonymous ,
I am afraid that there is no way to achieve your needs in Microsoft Flow currently.
There is no options about group by with the 'List records' action.
You can use the 'Filter array' action to get the records you want.
Best Regards,
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for help. But I am looking for group by createdby user to get count of all activities created by user today.
Hi @Anonymous ,
It seems you want to get the records which was created on today and order by createdby.
I have made a flow for your scenario, please check it for a reference.
Best Regards,
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am trying to get count of activites created today group by Createdby. For this, I am using List record template of Commom Data Service.
Hi @Anonymous ,
Could you please share a screenshot of your flow's configuration?
It seems you want to filter the records of a dynamic entity.
Could you please explain your scenario more clearly?
Best Regards,
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional