Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

GroupBy on createdby

(0) ShareShare
ReportReport
Posted on by

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.

  • v-zhos-msft Profile Picture
    on at
    Re: GroupBy on createdby

    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.

    Capture3.PNG

    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.

  • Community Power Platform Member Profile Picture
    on at
    Re: GroupBy on createdby

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

  • v-zhos-msft Profile Picture
    on at
    Re: GroupBy on createdby

    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.

    Capture5.PNG

    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.

  • Community Power Platform Member Profile Picture
    on at
    Re: GroupBy on createdby

     

    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.

  • v-zhos-msft Profile Picture
    on at
    Re: GroupBy on createdby

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow