Adding and displaying multiple comments for same customer with a date and time stamp

[ttaylor]

I have two Sharepoint lists - one name Contacts, the other named Notes.

When a rep visits a customer, I want them to be able to see notes from a previous visit (View) and then add a new note for this visit (basically appending rows in the Notes list). 

I've tried several scenarios and can't seem to find the best solution.

Any ideas?

[mdevaney]

@ttaylor 

Here's one way you could do it:

• Create a gallery containing contacts (galleryContacts)
• Set the Items property of galleryContacts to the Contacts datasource
• Create a gallery containing Notes (galleryNotes)
• Set the Items property of galleryNotes to Filter(notes_sharepoint_list_datasource, galleryContacts.Selected.ID = ContactID)
• (ContactID would be a column in your Notes datasource containing the unique ID number of the contact)
• Now when the user clicks on a contact name it will display the contact's notes
• Add a form (frm_addNote) in the state FormMode.New. Include any fields you require.
• Add a submit button and use the following code:  Submit(frm_addNote); Refresh(your_notes_datasource_name_here).
• Now when the user clicks Refresh the note will be submitted and the Gallery will be refreshed, showing the most recent note

That's my take on a general approach to the app design.

---

Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly.  If your thought the post was helpful please give it a "Thumbs Up."

[ttaylor]

Hmmm...I'm getting an Invalid Argument Type on GalleryNotes when I type in the filter info you provided. 

I used the Organization field in my contacts gallery (GalleryContacts). They all show up.

Added the a new gallery for notes (GalleryNotes) and typed

     Filter(GalleryNotes, GalleryContacts.Selected.ID = ID).

Since the rep might be visiting a different person in the organization each time, I want the notes to be tied to the organization.

I hope that makes sense. 🙂

[mdevaney]

@ttaylor 

The reason you are seeing an Invalid Argument Type is because ID has to exist in the contacts gallery.  I did not explictily say this earlier so I can understand your confusion.

However, from reading your post I can tell you want Notes to be tied to the organization instead.  I'd make the following changes:

• Create a gallery containing contacts (galleryContacts)
• Set the Items property of galleryContacts to the Contacts datasource
• Create a gallery containing Notes (galleryNotes)
• Set the Items property of galleryNotes to Filter(notes_sharepoint_list_datasource, galleryContacts.Selected.OrganizationID = OrganizationID)
• (OrganizationID would be a column in your Contacts datasource containing the unique ID of the organization (i.e. vendor code)
• (OrganizationID would ALSO be a column in your Notes datasource containing the unique ID of the organization (i.e. vendor code)
• Now when the user clicks on a contact name it will display the contact's notes
• Add a form (frm_addNote) in the state FormMode.New. Include any fields you require.
• Add a submit button and use the following code:  Submit(frm_addNote); Refresh(your_notes_datasource_name_here).
• Now when the user clicks Refresh the note will be submitted and the Gallery will be refreshed, showing the most recent note

Let me know if this helps!

[ttaylor]

I used a LookUp on Organization in my Notes list to get that info from my Contacts list. 

[mdevaney]

@ttaylor 

Is your datasource a Sharepoint list?  LookUp columns are considered to be a complex column type containing both an ID and a Value.  You probably want the value.  Here's how to do it by changing my code above.

Filter(notes_sharepoint_list_datasource, galleryContacts.Selected.OrganizationID = OrganizationID.value)

[ttaylor]

It is a SharePoint List. I used this Filter:

     Filter(GalleryNotes, GalleryContacts.Selected.OrganizationID = OrganizationID.Value)

and I'm still getting an invalid argument on my GalleryNotes table. 

From what I understand, by using a LookUp I don't need a unique Identifier in my tables, correct?

You have been so kind in helping me. I really appreciate it!

[mdevaney]

@ttaylor 

Maybe, its because we should change the Items property of the GalleryNotes to reference the SP List datasouce instead of a gallery:

Filter(notes_sharepoint_list_datasource, GalleryContacts.Selected.OrganizationID = OrganizationID.Value)

No problem.  We'll keep on plugging away at this.  I feel like the solution is within reach!

[ttaylor]

Sorry...no luck. Doesn't seem to like the OrganizationID:

Filter(Notes, GalleryOrgs.Selected.OrganizationID = OrganizationID.Value)

[yashag2255]

Hi @ttaylor 

Can you share more details about the schema of both the sharepoint list and their relationship?

You can use either Edit Form to update an existing record or create individual controls. If you can share more information about the requirements, then I might be able to help you with formula building.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!