web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create PowerApps. A re...
Power Apps
Unanswered

Create PowerApps. A repeating table with Cascading drop down list

(0) ShareShare
ReportReport
Posted on by 387

Hi PowerApps veterans,

 

I am hoping to create a table in PowerApps like the diagram below, I am wondering if you could point me to the right direction how I could get started. I would like to dive in PowerApps and learn how to create something useful like this and hope that this thread will be the definitive post and benefit anyone in the future, who faces similar requirements.

 

table.png

 

 

Thank you.

 

table.png
Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    154,799 Most Valuable Professional on at

    Hi @Australia ,

    A fairly broad question, but yes that is certainly possible in Power Apps. You would use a Gallery with editable functions included. How you approached it would depend if you wanted to save one line at a time (simpler) or the lot at the end (more complex).

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • Australia Profile Picture
    387 on at

    Hi @WarrenBelz,

     

    Many thanks for the prompt reply. I am glad to hear that it is possible to do it in Power Apps.

    I have updated my diagram so that it is easier to understand what I'd like to achieve.  I would hope to save the lot at the end by clicking the 'Save' button illustrated in the diagram.

     

    Thanks again.

  • WarrenBelz Profile Picture
    154,799 Most Valuable Professional on at

    Hi @Australia ,

    'As I mentioned, this makes the process more complex - you would need to have a collection as the Items of the gallery and Patch each one line as you complete it, then use a ForAll() patch from the collection to the list.

    Happy to look at your code it you get stuck on this.

    PS I am in your time zone - from CQ.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • Australia Profile Picture
    387 on at

    Thank you @WarrenBelz 

    To get started, could you correct me if my steps are wrong:

     

    1. Use the Data SharePoint list as the 'parent' list and the cascading SharePoint List as the 'child' list

    2. Create a PowerApp under the child list  (Power Apps > Create an App)

    3. Find supporting materials on how to create repeatable table and cascading list. Combine the two together.

     

    Should the 'Number of Parks' be created as a column in the Parent/Child list? Or both?

     

  • WarrenBelz Profile Picture
    154,799 Most Valuable Professional on at

    Hi @Australia ,

    You need a collection for the "Child list" in the gallery. What is your Power Apps experience (as this is not a straight-forward exercise).

  • Australia Profile Picture
    387 on at

    @WarrenBelz, would the childlist be the Data list or the cascading list?

    I am a newbie in the PowerApps world with very basic knowledge about Gallery/coding. Hence I've been searching for step-by-step materials on the web... (facepalm)

  • WarrenBelz Profile Picture
    154,799 Most Valuable Professional on at

    @Australia ,

    Please take the time to watch this video from Dave's Tech Tips @DavesTechTips - there are some fundamental things that you will need to understand before you attempt what you require. They include

    are a few I can think of straight away.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Australia Profile Picture
    387 on at

    @WarrenBelz Thank you very much Warren! Looks like I've already watched Dave's video so I guess that's a good start. Once I have learnt about Patch/Collect/Forall and other commands, what would be the next item(s) I should tackle?

  • WarrenBelz Profile Picture
    154,799 Most Valuable Professional on at

    Hi @Australia ,

    Those four are essential to build the type of model you need and you require an understanding of how they work.

    As I mentioned, I am happy to look at the code you have tried once you have your structure in place.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I am able to use repeating table for text fields and simple dropdown fields. But I facing issue with Cascading dropdown in repeating table. Can anyone share the formula's or guide how to do this?

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard