cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhruvin
Super User
Super User

Related Table Immediate Refresh Not happening for One to Many Relationship Table

I have two Dataverse tables with (one to many relationship in place) :

1.  Country

2.  Tickets

 

I'm creating below requirements.

First Country is shown as Dropdown.

Dhruvin_0-1645146036375.png

 

Based on selected Country I'm showing Tickets here!

 

Dropdown1.Selected.Tickets

 

Dhruvin_1-1645146158030.png

 

On the Same Screen I'm having new Button which is opening the NewForm and and Pre-Populated Selected Country from Dropdown. Once user click on Save, the form submitted successfully.

Dhruvin_2-1645146407221.png

 

New Button Code: NewForm(Form1_1)

Save Button Code:  SubmitForm(Form1_1)

 

Challenges / Issue:

1. When I Save, the record is submitted successfully. But it is not reflected to the Grid Automatically! I need to Refresh Entire App again to check the fresh data.  - This is main Issue. Related Table's data not getting reflected! 

 

2. If I change the Gallery's Item Code with following line, everything working as expected!

 

 

//Dropdown1.Selected.Tickets
Filter(Tickets,Country.Country = Dropdown1.Selected.Country)

 

 

Dhruvin_3-1645146868201.png

 

 

Why Dropdown1.Selected.Tickets not automatically pull fresh Records? I also try to add Manual Refresh using Refresh Button. Still it is not working! Any thoughts on this? What is the best way to use Relationships?

 

1 ACCEPTED SOLUTION

Accepted Solutions
rampprakash
Super User
Super User

Hello @Dhruvin 

 

When ever you filter the Gallery you need to User FILTER Option, that will load all the Data from the Table in a record, so that's why after using Filter option the data is populating correctly.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

View solution in original post

3 REPLIES 3
dpoggemann
Super User
Super User

Hi @Dhruvin ,

 

Please see the following post which I hope is the same issue you are having.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-force-a-Gallery-to-refresh-its-cards/...

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
rampprakash
Super User
Super User

Hello @Dhruvin 

 

When ever you filter the Gallery you need to User FILTER Option, that will load all the Data from the Table in a record, so that's why after using Filter option the data is populating correctly.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Thanks! That answers my question!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,955)