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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Answered

Gallery or form?!

(0) ShareShare
ReportReport
Posted on by

Hi!

I'm having a hard time tryng to do (what I think it is) a simple task in PowerApps. My data is an Excel table with 3 columns: category, subcategory and value.

I want to filter the categories and subcategories in order to update their values. The final result should look something like the print below:

BabyShark_0-1618249214638.png

 

My biggest problem is that I can't tell if I should do it using a gallery with a patch function to update the values, or if the best way to do it is using a edit form.

  • When I tried to do it using a gallery, all the subcategories were displayed and kinda polluted the design. I wasn't able to just put a dropdown like I wanted to.
  • Also, when I tried to do it using an edit form, even when I set the card's display mode to "view", nothing showed up in the screen when I ran the app. Since I don't want to add data to my database, setting the display mode to "new" doesn't apply in my case.

What am I doing wrong? Any help or hint would be appreciated. Have a great day.

 

 

Categories:
I have the same question (0)
  • Verified answer
    eka24 Profile Picture
    20,923 on at

    I suggest you use the form.

    Set the Default Mode to Edit. 

     

    Insert a Gallery and put the Datasource on the items property of the Gallery.

     

    Then,

    On the Item property of the Form put: Gallery1. Selected

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard