Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

My related tables has stopped working in gallery

(0) ShareShare
ReportReport
Posted on by 892

Been focusing on another project for 2 weeks and when I started to edit my PowerApps canvas today I had errors on the galleries. This code has been working for months and I am not understanding what has changed. If Microsoft has changed things or what could be the issue.

 

Here are my examples.

 

On Gallery with a list of Courses. I have counted the rows of a Bookings table linked to the Course. On the Bookings table I have a lookup to Courses. I have used this formula to count the rows in that related table. Why has it stopped working when it has worked before?

Screenshot 2022-03-28 at 09.58.15.png

Other example:

Screenshot 2022-03-28 at 10.50.51.png

Same related table lookup that is references. I'd love to understand what has changed.

 

Kind regards.

Categories:
  • Gyllentid Profile Picture
    892 on at
    Re: My related tables has stopped working in gallery

    Bo worries, this is Dataverse. Thanks for trying to help.

  • WarrenBelz Profile Picture
    146,651 Most Valuable Professional on at
    Re: My related tables has stopped working in gallery

    @shavora ,

    You did not state your data source (which I assume now is not SharePoint). I am a SharePoint user, so probably not the best person to comment.

  • Gyllentid Profile Picture
    892 on at
    Re: My related tables has stopped working in gallery

    It's not. In items I reference the Course table. This is in a Label in the gallery. Just displaying how many participants we have on each course. But see the other comment I made, it seems to work to just delete the relationship name now.

  • Verified answer
    Gyllentid Profile Picture
    892 on at
    Re: My related tables has stopped working in gallery

    Well, it seems to work without the long name of the relationship now. So just ....Selected.'Candidate bookings'). 

  • WarrenBelz Profile Picture
    146,651 Most Valuable Professional on at
    Re: My related tables has stopped working in gallery

    Hi @shavora ,

    Firstly, can I assume that the field 'Candidate bookings (key_CandidateBookings_Course_key_Coursesc)' is in the Items of your Gallery and is a Table?

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,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard