Answered

Update Edit form based of Gallery Choice

(0) Share

Report

Posted on by hitty08

I am running into an issue when I have a gallery linked to a sharepoint list, when I select that gallery it brings up an edit form to the right of the gallery.

I want to be able to update the context of that edit form to only display certain columns based off a choice within the gallery. Example

Gallery

Item 1 -- Sprint 1

Item 2 -- Sprint 2

Item 3 -- Sprint 3

Edit Form Choices

Title, Sprint, POC, Area

I want to be able to filter out area on the edit form if sprint 2 is selected. I have been trying an if statement within OnSuccess and Visiable of the form but nothing is working properly. Any ideas would be greatly appreciated.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

Deja vu! This was exactly where I was going on message 10 of your prior post.

You need no If statements for any of this, you simply need to set the Item property of your Form to the Gallery Selected record - yourGallery.Selected
hitty08 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Randy, followed that advice to the letter. I got that portion of it working.

This is one giant list, some items will be filled in, some wont based on the sprint. For example

Sprint one will have POC, Title, Date filled in, but sprint two will have POC, Title, Date and Project type filled in. Project Type is not filled in on Sprint 0. When I use yourGallery.Selected and click on and item that has Sprint 0, Project type shows up in the edit form.

I am trying to filter out the project type column on the edit form for any object that has sprint 0 assigned to it. So it will not show up in the edit form for the object that has sprint 0 assigned, but will show up in the object that has sprint 1 assigned to it.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

So in this scenario, you should simply be working with one form and set the Visible properties of the datacards you don't want to appear to false.

So, for example, if in Sprint 2, you want the Project type to be shown, then set the Visible property of that datacard to: ThisItem.SprintNumber.Value = "Sprint 2"

This will show that datacard when the sprint is 2. Now, you actually probably want the inverse to happen...

!(ThisItem.SprintNumber.Value = "Sprint 1") This will show the datacard at any time the Sprint is not Sprint 1 (so sprint 2, 3 and 4)
hitty08 79 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked perfectly, you are the man!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

I'm just glad our last post was still fresh in my head. With all the posts I deal with, that is actually a bit rare.