Edit gallery information

(0) Share

Report

Posted on by tjtaylor1164

Here is my question: How can users edit existing notes in a gallery? Below is are the details and screen captures.

I have the following scenario:

1. Notes screen displays information that has been collected from multiple meetings for one company (Notes = SharePoint list where company is a lookup field to Organization in SharePoint LIST2)

2. Organization is based on a combo box dropdown from previous screen.

3. Notes for the selected company are display via a gallery (gallery_Notes)

4. New notes can be added for this organization (form_NewNote).

5. Once a new note has been added, the gallery_Notes is updated with the most recent note at the top.

gallery_Notes

ITEMS = Sort(Filter(Notes,OrganizationNOTES.Value = ComboBox2.Selected.Organization),MtgDate, Descending)

Notes screen.PNG

If users select button to "Add New Meeting Information," a popup form collects the information. Information is added to the Notes SharePoint list. I have the organization field hidden on this form but below is the information:

UPDATE: = {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:ComboBox2.Selected.ID,

Value:ComboBox2.Selected.Organization}

DEFAULT = ThisItem.OrganizationNOTES (organization is lookup field to SharePoint LIST2)

Save Meeting Details Button:

SUBMIT: SubmitForm(form_NewNote); Refresh(Notes); UpdateContext({Popup: false})

Popup screen.PNG

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tjtaylor1164

First, the Item property of the NewNote Form should be Lookup(Notes, ID=gallery_Notes.Selected.ID). This is important for editing the form but is ignored for new forms. It specifies the record in your list that is being edited as the one selected in your gallery.

Next put a > icon inside the gallery so that it appears with each item; make its OnSelect property: EditForm(form_NewNote); UpdateContext({Popup:true}). This will bring up the popup edit form and the form will be populated by the information in the selected item in the gallery. The EditForm(form_NewNote) sets the form's mode to Edit. To open the form in New mode, NewForm(form_NewNote);UpdateContext({Popup: true}) should be in Add New Meeting button that creates a new note to ensure that the form opens in New mode.

Currently your Save button is SUBMIT: SubmitForm(form_NewNote); Refresh(Notes); UpdateContext({Popup: false}). It should only have SubmitForm(form_NewNote) in this button. The Refresh(Notes); UpdateContext({Popup: false}) commands should be in the OnSuccess property of the form. You don't want these commands chained to the form submission button because they will execute regardless of whether the form is successfully submitted. By using the OnSuccess property, the popup will disappear only if the form is submitted successfully.

Was this reply helpful? Yes No
tjtaylor1164 30 on at

Like
a
(0)

Report
Copy link

Link copied!

I apologize but I think I'm confused.

You mention "Next put a > icon inside the gallery so that it appears with each item; make its OnSelect property: EditForm(form_NewNote); UpdateContext({Popup:true})"

I did a quick screen capture of a small part of my gallery:
As an example, this means I would add the icon beneath "lbl_FollowupLead3Notes"? And then do that for each one? (Anything that has Heading in the title is just the text included in front of the label.)

So then if they user wants to edit the third note in the example below dated 4/9, it would pull up the correct information.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tjtaylor1164

Put a > icon in the first item of the gallery. It will propagate down the entire gallery. It is used to select the record in the gallery.

Was this reply helpful? Yes No
tjtaylor1164 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! That's what I originally did but it didn't work so I was second guessing myself.

I just created a new gallery with the same information with an icon and it works fine.

Just one more quick question, when I go in to edit meeting info, it doesn't keep the date information.

Thanks you so, so much.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tjtaylor1164

Try deleting the date card from the form and then adding it back in again. If that doesn't work please post a screenshot of the edit form.

Was this reply helpful? Yes No
tjtaylor1164 30 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked!! Thank you!

Was this reply helpful? Yes No