cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pmcconnell117
Microsoft
Microsoft

Building Live Glossary

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
FMontesRNX1
Resolver II
Resolver II

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

View solution in original post

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

View solution in original post

4 REPLIES 4
FMontesRNX1
Resolver II
Resolver II

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

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?

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

You're a godsend! Thank you so much!

All works out fantastic, can't wait to share with the team. 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,655)