cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ghdunn
Post Patron
Post Patron

Subform or Sub-Grid in Canvas Apps

Firstly, thanks for all of the great support the community is offering in helping me up the curve of Power Apps!

 

I am trying to do the simplest of things and I am sorry if I am just not quite getting it.

 

I want a form and sub/form to View/Edit two lists in SharePoint, which have a 'relationship' of a lookup.

 

In simplest terms:

 

Account

a

b

 

 

Contact,Account (looked up from Account)

x,a

y,a

z,b 

 

In Microsoft Access I have a very simple way of including a Subform into a Form to access.  In Model Driven Apps this seems to be similarly easy...to add a Sub-grid.

 

However in Canvas Apps this seems not to be quite so straightforward. 

 

I have looked at this solution, and I am not sure it fully resolves explains how to do this, or not in a way I understand.

https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApp-Creating-a-subForm-in-a-form/m-p/36...

 

I have watched these videos which talks about Repeating Tables.  I did emulate Shane's solution, but it just seems to elaborate given how easier the other solutions are. Is it really this involved?

https://www.youtube.com/watch?v=xgznk4XlPCo&list=PLCGGtLsUjhm2bonhBZuEhZU72QkFjOpc6&index=36&t=0s

 

If I google 'sub-grids' then I get lots of references to Model Driven Apps, but nothing simple/elegant for Canvas.

 

Can anyone point me to a simple solution that would allow this very simple form/sub-form:

 

Capture.PNG

 

 

35 REPLIES 35
PowerAddict
Most Valuable Professional
Most Valuable Professional

To be sure, here are the requirements:
1. Ability to edit a Contact record
2. Ability to add a new Contact record
3. Ability to edit Account data (not sure if you meant this by saying writing the Account data back???)

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

1. Ability to edit a Contact record - yes
2. Ability to add a new Contact record - yes
3. Ability to edit Account data (not sure if you meant this by saying writing the Account data back???) - what i mean is that having done '2' and pressed 'save' it needs to be smart enough to update the AccountField field in the Contact table even though that field isn't in the ContactGallery

 

in short..to replicate the functionality of a Form/Sub Form.

PowerAddict
Most Valuable Professional
Most Valuable Professional

The reason your gallery wasn't editable is because the controls you had within your gallery were labels. You need to replace them with input controls like text input, dropdown, combo boxes etc. 

 

Anyways, attached is what I believe meets all your needs. If it does, please let me know and I will share the details. Here are the steps I followed:

1. Account a has 2 contacts x and y

2. Account b has 1 contact z

3. I modified contact x to link to account b

4. Account a now has 1 contact y

5. Account b now has 2 contacts x and z

6. I created a new contact Hardit and linked it to Account a

7. Account a now has 2 contacts Hardit and y

 

Note: I have not focused on the UI or any other details e.g. the gallery default view should be read only and when an edit icon is clicked, the view should change to allow edits. This is pretty easy to achieve once the desired functionality is achieved. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Hardit,

 

I have run out of time to replicate this just right now.  I will look at it first thing to confirm

 

Very many thanks for your FANTASTIC efforts to help me out, man...great job!

 

Gerald

PowerAddict
Most Valuable Professional
Most Valuable Professional

No worries at all. In the meantime, I have attached a document that shows each control in detail. Hopefully, this will help you implement the same on your end. 

 

Let me know in case of any questions or I missed any details in the document. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

@ghdunn did you get a chance to test this out? If your problem is resolved, please consider giving kudos and mark the reply as an accepted solution so others can find it easily.

Thanks,
Hardit Bhatia
https://thepoweraddict.com

@PowerAddict 

Hardit,

 

I am sorry I didn't reply yesterday.  I spent quite a lot of time yesterday on this, googling around.

 

I think your solution is abslutely fine from a purely functional point of view, however (and, please understand, this is no criticism!) it lacks the simplicity/elegance I was looking for compared to the sub grid functionality in Model Driven Apps. It is clearly a reflection of the (obvious) deficiencies of Sharepoint as a 'database' - I wonder whether over time sharepoint will move towards CDS or perhaps Canvas App capabilities are still mature.

 

Very grateful for all of your efforts...i have learned a lot

 

What are your thoughts?

 

Gerald

@Pstork1 

 

Sorry for belated response but worked through a similar route with @PowerAddict .

 

I think I now recognise this is the reality given the underlying data source but was hoping for more of an out of the box solution.

 

Thanks once again for your support!!

 

Gerald

PowerAddict
Most Valuable Professional
Most Valuable Professional

No worries at all, its always fun to research things!

I think it all boils down to the expected functionality and choosing which type of app will better meet your needs. In this case, while a sub grid might look like an easier option, it doesn't give you the same UI and customizing options like a canvas app (conditional formatting is much simpler in a canvas app, there are many more examples). If you haven't noticed by now, I am a bit biased towards canvas apps 🙂

That being said, whenever I have to make a choice between 2 things, I always hope to get the best of both worlds. Which is exactly what embedded canvas apps do! In this case, if a sub grid better meets your needs, you can have that on a model-driven form but embed a canvas app for something else (I typically use them when there is a guided process which can easily become clunky in a model-driven app if the user has to navigate to multiple screens).

Also, in this case, I really don't think having CDS as your data source would have made much of a difference. The high level approach would have still been the same. I personally don't think (and hope) that SharePoint will move towards CDS (if you meant CDS will replace SharePoint). They both have their own advantages with document storage/management being a big plus of SharePoint. As far as Canvas app capabilities are concerned, capabilities with SharePoint are pretty decent in comparison to CDS, it could probably have a better list of delegable functions, but we all know that Microsoft keeps adding functions to that list.

So I would say stick to a model-driven app if it meets your needs and UI is not your main focus. If you still want UI and some extra customization capabilities, switch to a standalone canvas app. Or use embedded canvas apps if you want to take advantage of both in your solution.

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
Anonymous
Not applicable

 

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!   This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08  23 @WarrenBelz  31 @DBO_DV  10 @Amik  19 AmínAA 6 @mmbr1606  12 @rzuber  4 @happyume  7 @Giraldoj  3@ANB 6 (tie)   @SpongYe  6 (tie)     Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08  10@WarrenBelz 25 @DBO_DV  6@mmbr1606 14 @AmínAA 4 @Amik  12 @royg  3 @ANB  10 @AllanDeCastro  2 @SunilPashikanti  5 @Michaelfp  2 @FLMike  5 @eduardo_izzo  2   Meekou 2   @rzuber  2   @Velegandla  2     @PowerPlatform-P  2   @Micaiah  2     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27     Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8   SunilPashikanti8

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (818)