cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Helper V
Helper V

Use Subgrid on recurrence form to view data from a related table.

Hi,

I am trying to use  a Subgrid to view data from a related table on Appointment table. It just gives me generic tables and not custom tables option when configuring Subgrid on the recurrence form. I was able to add a subgrid to fetch related information from the Appointment table. Not sure what configuration I am missing on.

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User II
Super User II

You need to have a Recurring Appointment lookup column/field on the desired entity/table to see the related entities. The list you see there are the out-of-the-box on Recurring Appointment lookups on other entities.

View solution in original post

4 REPLIES 4
EricRegnier
Super User II
Super User II

Hi @Teresa24486,

Are you trying to add the subgrid on an Appointment form or on an Recurring Appointment form (these are two are different entities/tables). When adding the subgrid, check "Show related records" option:

2021-01-05_10-59-28.png

Hope this helps!

hi @EricRegnier ,

I am using Subgrid on Recurrence form from classic mode and I see only these options:

Teresa24486_0-1609824170306.png

While I wanted to see my custom table's related records.

EricRegnier
Super User II
Super User II

You need to have a Recurring Appointment lookup column/field on the desired entity/table to see the related entities. The list you see there are the out-of-the-box on Recurring Appointment lookups on other entities.

View solution in original post

hi @EricRegnier ,

The appointment table already has a relation with the custom table. I have created a custom lookup column from the recurrence table to my custom table. It still doesn't show any custom tables.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,033)