Unanswered

Filter Activities based Activity Type

(0) Share

Report

Posted on by necsa

Hi all experts,

I would like to filter Activities based on Activity Type using Canvas App Gallery. I tried but I cannot get the Activity Type Optionset in the Canvas App when I try to filter. Is there any solution or suggestion to filter Activity based on Activity Type?

thanks in advance

Categories:

Building Power Apps

I have the same question (1)

All responses (8)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Necdet ,

Hopefully you can find your scenario in this guide how to filter a Dataverse Choice column: https://www.d365geek.co.uk/single-post/filtering-by-choice-columns-in-dataverse-and-power-apps-what-are-my-choices

Was this reply helpful? Yes No
necsa 24 on at

Like (0)

Report

Thanks for the rapid answer. This page and information are known did you try it? Is it working with Activities? The Activity Type is Global Choice and I didn't find a solution to filter it. Please if you try and get any solution I'll be thankful when you share here. Thanks in advance.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Necdet ,

I did a quick test using a combobox using the Activities table for the Items property and a gallery with the below formula for its' Items property which seems to work as expected:

Filter(Donations, Activity in ComboBox1.SelectedItems.Activity)

Was this reply helpful? Yes No
necsa 24 on at

Like (0)

Report

Hi @BCBuizer ,
I appreciate your time and answer. But this is only the value of the activity id. I mean activity type. When I filter activities I want to get separate with activity types like "Email", "Appointment", "tasks" or "Phonecall". Can you define with this ID what type of activity are you handling?

Was this reply helpful? Yes No
rodrigopuravida 12 on at

Like (0)

Report

Hi,
Were you able to solve your issue? I came across the same thing !!!
Thanks in advance

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @rodrigopuravida , @Necdet ,

Have you tried using the Choices function to access the optionset: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-choices

This should return the optionset values as well as the ids.

Was this reply helpful? Yes No
rodrigopuravida 12 on at

Like (1)

Report
Hi,
To make a long story short this is what I did to work around this issue:
on the Items property added a column (AddColumns with name e.g. ActivityTypeAdded) with the Activities table as datasource, the new column name and then the following as third argument so based on the record it will populate the new column with that value as text.
Once that is in place I can filter on the new column and can forget about the 'non appearing' activity type table. If I could see the column ActivityType this would have been way easier but I can't so had to make it work.
Sort of looks like this
Filter(
AddColumns(
Filter(
Activities,
Regarding = [@ModelDrivenFormIntegration].Item,
Or(
'Activity Status' = 'Activity Status (Activities)'.Completed,
'Activity Status' = 'Activity Status (Activities)'.Canceled
) && ('Activity Status' = drp_ActivityStatus.Selected.Value || drp_ActivityStatus.Selected.Value = Blank())
),
"ActivityTypeAdded",
If(
IsType(
ThisRecord,
[@'Email Messages']
),
"Email Message",
IsType(
ThisRecord,
[@'Phone Calls']
),
"Phone Calls",
IsType(
ThisRecord,
[@Letters]
),
"Letter",
IsType(
ThisRecord,
[@Faxes]
),
"Fax",
IsType(
ThisRecord,
[@Appointments]
),
"Appointment",
IsType(
ThisRecord,
[@'QC Phone Calls']
),
"QC Phone Call",
"No Entity Found"
)
),
ActivityTypeAdded = drp_ActivityType.SelectedText.Value || drp_ActivityType.SelectedText.Value = Blank()
)

Was this reply helpful? Yes No
rodrigopuravida 12 on at

Like (1)

Report

oh and thank you for your feedback btw.

Was this reply helpful? Yes No