Answered

Building Live Glossary

(0) Share

Report

Posted on by Pmcconnell117 Microsoft Employee

Hi everyone,

I'm trying to build a "Live" glossary for our team that allows users to submit terms & definitions, but rather than having to edit the definition, it automatically adds the new submission as a new line within the description of the given the line item.

The goal is to eliminate the need for someone to come in and manually add/format each new submission for an already existing term.

For example: User 1 submits the acronym XYZ. User 2 comes in a month later to add another definition to XYZ. Rather than it showing as the submitted definition from User 2, it shows User 1's submission at the top, followed up User 2's submission.

Ideal format:

Term: XYZ

Definition:

1. User 1 Submission

2. User 2 Submission

Not Ideal/Current:

Term: XYZ

1. User 1 Submission

Term: XYZ

1. User 2 Submission

My first thoughts were to utilize the Lookup & Append functions between two different lists.

First would be to validate that the Terms among the multiple submissions, and then append all description submissions and separate them using a comma.

Is this possible? If so, is there any way to format this into a bullet form?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

FMontesRNX1 147 on at

Like
a
(1)

Report
Copy link

Link copied!

OK consider the following:

List 1:
List of words only [1 column: Word]
List 2:
List of definitions [Word, Definition]
List 3: (optional)
Local collection with elements from A to Z [1 column: Letter]

Now, on your app, you can use 2 (or 3) galleries:
First Gallery will show first list with the words list (or A to Z list if you're using the option), next, filter the next list based on the previous value.
Example (only words and definitions):
On definitions list:
Filter(DefinitionsList,Word = Gallery1.Selected.Word)
And show this fields: Definition and (optional) Created, Created By).

If you'll use the 'A to Z' list, will add only the filter on Words List.
Filter(WordsList,StarsWith(Word,Gallery2.Selected.Letter)
Will show only the 'Word' field.
Finally add a TextInput to add Search function and adjust the design.
Hope it helps

Was this reply helpful? Yes No
Pmcconnell117 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This worked out great!
In regards to the form to allow users to submit the new terms, this should be connected to the 'Definitions' list, correct?
If so, should I have the column in my 'Word' List Lookup what the terms are in the 'Definition' list to ensure that new ones are being displayed in the gallery? Otherwise, wouldn't we need to manually add the new terms to the 'Word' list?

Was this reply helpful? Yes No
Verified answer

FMontesRNX1 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi.
It's correct, new definitions on your Definitions list, only restrict users to edit all the registry, for example, hide the 'Word' data card and set on Default the Gallery containing the word you're adding a definition, something like:
Default: Gallery2.Selected.Word
By this way, you can put an 'Add' button to navigate to your form and add definitions for the selected Word,
Now, for new words, you can add another screen with 2 forms on it, 1 for word, and 1 for definition, by this way, anyone who add a new word on Word's list, will be able to add on same screen the first Definition and don't require to add a word on 1 screen, and then use another screen to add definitions, but this will depend your expectations about GUI.

Extra:
You can set controls for delete unwanted definitions, or, inclusively, require Microsoft Approvals to add new definition 😉

Hope it helps

Was this reply helpful? Yes No
Pmcconnell117 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You're a godsend! Thank you so much!
All works out fantastic, can't wait to share with the team.

Was this reply helpful? Yes No