Activities Table not displaying ActivityTypeCode column in Canvas App Gallery

[rodrigopuravida]

Hi,

I'm working on a Canvas app which has the Activities Table as a data source.  I noticed the ActivityTypeCode Column is not showing as a choice within the Gallery (e.g. use as  ThisItem.ActivityType ) and if the column is not there how can  we perform any filtering?

I was able to display the type of Activity on a label by using this code:

If( IsType( ThisItem, Faxes ), "Fax",

    IsType( ThisItem, 'Phone Calls' ), "Phone Call",

    IsType( ThisItem, 'Email Messages' ), "Email Message",

    IsType( ThisItem, Letters ), "Letter",

    IsType( ThisItem, Appointments ), "Appointment",

    "Unknown"

)

So to recap - trying to use the ActivityTypeCode column within the Filter function  - any suggestions???

Thanks in advance

[MMPoweR]

To display dropdown values in your Gallery, you can use the code below.

ThisItem.ActivityType.Value

To filter using Activity Type, you can use the code below in your Gallery Items property to search Activity Type via text input (you can use other controls, not just text input, this is only for sample purposes).

Filter('Activities Table',actSearchInput.Text in ActivityType.Value)

Actual Results.

No filter

Filter by Appointments

Filter by Letters

[rodrigopuravida]

Hi,

Thank you for your reply.  That is what I use with any Fields I can see because the columns DO show in Intellisense.  My question was around the fact that ActivityType is not recognized so none of it works.  See below.  Thank you again for replying though

[MMPoweR]

I don't quite get what you want now, can you share further details about the your issue along with a screenshot?

[rodrigopuravida]

Hi again,

All I am saying is that after I add the Activities Table as a DataSource to my Gallery the 'ActivityType' Column is not displayed in intellisense so I am NOT able to do

ThisItem.ActivityType.Value

 like in your screenshot.  If you see my screenshot above you see Activity, ActivityStatus, Actual duration, etc but there is NO ActivityType.  My question was in regards to if anyone knows why this could be happening.

Again thanks for taking the time to read this.

[Powerappsuser14]

Hi @rodrigopuravida ,

    I have also same requirement,Activities dataverse table added to canvas app gallery.Yes,activity type not shown unable to update value in gallery.

Do you achieve this issue please help to provide solution to achieve thisone.

Thanks in advance for quick response.....!