Unanswered

GroupBy on createdby

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for help. But I am looking for group by createdby user to get count of all activities created by user today.

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No