Notifications
Announcements
I am using two tables under the report wizard in powerapps. The issue then comes from the tables that I am using. Table 1 has a one-to-many relationship with Table 2. Now when I create the report the values do not transfer over and come blank. Is this some sort of relationship issue in the tables and does not realize that the data is connected. What would I need to do?
Hello, @jbmonte , check this documentation and verify that you have Step#5 correctly:
https://docs.microsoft.com/en-us/power-apps/user/create-report-with-wizard
Regards,AhmedIf my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.
Yes I have done that and made sure the relationships were going in the right direction.
I am still getting the same issues
Hello @jbmonte, sorry for the delay, I was trying to recreate your issue but I couldn't. But here what I did and my report worked just fine:
Let me know if following my steps will help you with solving the issue.
I did what you did and it still does not work, I am not sure if there is an issue with my custom tables or the relationship between them. I have tried flipping the many-to-one on both ends and I get the same issue. The data will come up blank for whichever table has the many part.
@jbmonte, How did you load the data into the Lookup Column in the Many Table?
What exactly should be put in that lookup column, as of now it is blank on the many table
@jbmonte, that is why you don't get the many data on the report. The Lookup column should have the value of the One Table record. Fill the column in the edit designer of the table. Let me know if you don't know how. NOTE: the values that will populated for you (Not hard typing) is the values of the Default Name Column in your One Table.
Okay that fixed everything, is there a way that does not involve manually inputting the data for that column?
@jbmonte , yes, to use Dataflows to load the data into the many Table. you have to make sure that your ONE table has an Alternate Key setup (which should be the column that has the unique values, and they are the same values you are using in the many table as foreign keys).
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 717 Most Valuable Professional
Michael E. Gernaey 329 Super User 2025 Season 2
Power Platform 1919 268
