SOLVED

SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1965687%22%20slang%3D%22en-US%22%3ESharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1965687%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20create%20something%20on%20SharePoint%20where%20500%2B%20people%20can%20go%20and%20nominate%20any%20person%20within%20the%20organization%20for%20a%20category.%20There%20are%205%20different%20categories%20and%20the%20idea%20is%20to%20have%20everyone%20go%20and%20nominate%20someone%20in%20the%20category.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20you%20make%20it%20so%20that%20no%20one%20deletes%20a%20previous%20nominee%20name%20and%20just%20able%20to%20add%20onto%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20too%20sure%20if%20a%20list%20would%20work%20or%20something%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumns%20would%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EName%20of%20Person%20(to%20be%20linked%20as%20using%20Office%20365)%3C%2FP%3E%3CP%3ECategory%20nominated%20in%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1965687%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1965847%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1965847%22%20slang%3D%22en-US%22%3EAre%20you%20using%20an%20older%20version%20of%20SharePoint%20or%20SharePoint%20Online%3F%20Either%20way%20an%20easy%20way%20to%20do%20this%20would%20be%20to%20go%20into%20the%20advanced%20list%20settings%20and%20update%20the%20item-level%20permissions%20so%20that%20users%20can%20only%20create%20and%20edit%20items%20they%20submit%20to%20the%20list.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20wanted%20to%20take%20it%20a%20step%20further%20you%20could%20separate%20the%20form%20from%20the%20list%20using%20SharePoint%20Designer%20in%20older%20versions%20of%20SharePoint%2C%20or%20Forms%20or%20PowerApps%20in%20SharePoint%20Online.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1965851%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1965851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F213123%22%20target%3D%22_blank%22%3E%40anthony%20tudor%3C%2FA%3E%26nbsp%3Bhi%2C%20am%20using%20SharePoint%20online%20for%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966256%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966256%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893158%22%20target%3D%22_blank%22%3E%40DrishM%3C%2FA%3E%26nbsp%3BWe%20do%20this%20in%20my%20company%20for%20the%20monthly%20awards%20scheme.%20A%20Microsoft%20Forms%20form%20on%20a%20SharePoint%20page%20is%20used%20for%20people%20to%20nominate%20colleagues.%20A%20flow%20in%20Power%20Automate%20gets%20each%20response%20and%20saves%20it%20to%20the%20list%20in%20SharePoint.%20It%20then%20gets%20the%20details%20of%20the%20nominee's%20manager%20and%20sends%20a%20confirmation%20email%20back%20to%20the%20responder%20and%20to%20the%20nominee's%20manager%20and%20also%20sends%20an%20email%20to%20the%20member%20of%20staff%20who%20is%20managing%20the%20scheme.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966262%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3Bthat%20actually%20sounds%20like%20it%20would%20work%20-%20would%20it%20be%20possible%20for%20you%20to%20share%20the%26nbsp%3B%3CSPAN%3E%26nbsp%3Bflow%20in%20Power%20Automate%20that%20you%20have%20used%3F%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1970362%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1970362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893158%22%20target%3D%22_blank%22%3E%40DrishM%3C%2FA%3E%26nbsp%3Bthe%20flow%20is%20as%20follows%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20the%20trigger%20is%20the%20Forms%20%3CSTRONG%3Ewhen%20a%20new%20response%20is%20submitted%3C%2FSTRONG%3E%2C%20followed%20by%20the%20first%20action%20to%20%3CSTRONG%3Eget%20response%20details%3C%2FSTRONG%3E.%20Note%20the%20%3CEM%3EList%20of%20Notifications%20Response%20ID%3C%2FEM%3E%20which%20you%20select%20from%20the%20dynamic%20content%20box%20has%20been%20replaced%20by%20%3CEM%3EResponse%20ID%3C%2FEM%3E%20but%20does%20exactly%20the%20same%20thing.%20Next%20we%20add%26nbsp%3B%20a%20Office%20365%20Users%20%3CSTRONG%3Eget%20user%20profile%20(v2)%3C%2FSTRONG%3E%20and%20populate%20it%20with%20%3CEM%3EResponder's%20Email%3C%2FEM%3E%20from%20the%20dynamic%20content.%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20592px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238980i3518449CAC24A907%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%26nbsp%3B2.%20Next%20add%20another%20Office%20365%20Users%20%3CSTRONG%3Eget%20user%20profile%20(v2)%3C%2FSTRONG%3E%20and%20select%20the%20question%20from%20the%20form%20where%20you%20asked%20for%20the%20email%20address%20of%20the%20nominee.%20The%20administrator%20of%20the%20scheme%20wanted%20the%20employee%20number%20which%20in%20our%20company%20is%20stored%20in%20the%20Nickname%20field%20in%20Delve.%20In%20the%20next%20action%20I've%20populated%20the%20column%20for%20the%20name%20of%20the%20nominator%20with%20their%20firstname%20and%20surname%20as%20in%20our%20company%20the%20display%20name%20is%20done%20differently.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20609px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238978i3914318C21AD0396%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20Next%20we%20add%20the%20SharePoint%20%3CSTRONG%3Ecreate%20item%3C%2FSTRONG%3E%20action%20and%20populate%20the%20fields%20from%20the%20Get%20response%20details%20section%20of%20the%20dynamic%20content%20and%20the%20outputs%20of%20the%202%20compose%20controls.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-Flow.png%22%20style%3D%22width%3A%20604px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238977iE925DA9CE9AD119B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-Flow.png%22%20alt%3D%223-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.%20The%20administrator%20of%20the%20scheme%20wanted%20the%20nominee's%20manager%20to%20be%20informed%20of%20the%20nomination%2C%20so%20I%20added%20another%20Office%20365%20Users%20action%20but%20this%20time%20selected%20%3CSTRONG%3Eget%20manager%20(v2)%3C%2FSTRONG%3E%20and%20added%20the%20nominee's%20email%20in%20the%20User%20field.%20Next%2C%20we%20wanted%20to%20add%20the%20company%20logo%20to%20the%20emails%20being%20sent%20out%20so%20to%20get%20the%20file%20path%20I%20added%20a%20%3CSTRONG%3Eget%20file%20content%20using%20path%3C%2FSTRONG%3E%20action%20and%20selection%20the%20location%20within%20the%20intranet%20of%20the%20logo.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-Flow.png%22%20style%3D%22width%3A%20594px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238979iB9CA688B804D3F82%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%224-Flow.png%22%20alt%3D%224-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5.%20Next%2C%20using%20a%20%3CSTRONG%3Esend%20email%20from%20a%20shared%20inbox%3C%2FSTRONG%3E%20action%20we%20send%20a%20confirmation%20email%20back%20to%20the%20submitter%20with%20details%20of%20what%20they%20submitted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%225-Flow.png%22%20style%3D%22width%3A%20628px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238991iCDB67988FDE851A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%225-Flow.png%22%20alt%3D%225-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B6.%20Finally%20an%20email%20is%20sent%20to%20the%20scheme%20administrator%20and%20the%20manager%20of%20the%20nominee.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%226-Flow.png%22%20style%3D%22width%3A%20591px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238982iA489881C947B3CE1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%226-Flow.png%22%20alt%3D%226-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1982090%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1982090%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F173457%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%20this%20is%20a%20great%20suggestion!%20I'd%20go%20with%20this%20too%20with%20the%20scenario%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893158%22%20target%3D%22_blank%22%3E%40DrishM%3C%2FA%3E%20has%20described.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I am looking to create something on SharePoint where 500+ people can go and nominate any person within the organization for a category. There are 5 different categories and the idea is to have everyone go and nominate someone in the category. 

 

How do you make it so that no one deletes a previous nominee name and just able to add onto it? 

Not too sure if a list would work or something else.

 

Columns would be:

 

Name of Person (to be linked as using Office 365)

Category nominated in 

6 Replies
Are you using an older version of SharePoint or SharePoint Online? Either way an easy way to do this would be to go into the advanced list settings and update the item-level permissions so that users can only create and edit items they submit to the list.

If you wanted to take it a step further you could separate the form from the list using SharePoint Designer in older versions of SharePoint, or Forms or PowerApps in SharePoint Online.

@anthony tudor hi, am using SharePoint online for this

@DrishM We do this in my company for the monthly awards scheme. A Microsoft Forms form on a SharePoint page is used for people to nominate colleagues. A flow in Power Automate gets each response and saves it to the list in SharePoint. It then gets the details of the nominee's manager and sends a confirmation email back to the responder and to the nominee's manager and also sends an email to the member of staff who is managing the scheme.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@Rob Elliott that actually sounds like it would work - would it be possible for you to share the  flow in Power Automate that you have used? 

Best Response confirmed by DrishM (Occasional Contributor)
Solution

@DrishM the flow is as follows:

 

1. the trigger is the Forms when a new response is submitted, followed by the first action to get response details. Note the List of Notifications Response ID which you select from the dynamic content box has been replaced by Response ID but does exactly the same thing. Next we add  a Office 365 Users get user profile (v2) and populate it with Responder's Email from the dynamic content.
1-Flow.png


 2. Next add another Office 365 Users get user profile (v2) and select the question from the form where you asked for the email address of the nominee. The administrator of the scheme wanted the employee number which in our company is stored in the Nickname field in Delve. In the next action I've populated the column for the name of the nominator with their firstname and surname as in our company the display name is done differently.

2-Flow.png

 

3. Next we add the SharePoint create item action and populate the fields from the Get response details section of the dynamic content and the outputs of the 2 compose controls.

3-Flow.png

 

4. The administrator of the scheme wanted the nominee's manager to be informed of the nomination, so I added another Office 365 Users action but this time selected get manager (v2) and added the nominee's email in the User field. Next, we wanted to add the company logo to the emails being sent out so to get the file path I added a get file content using path action and selection the location within the intranet of the logo.

4-Flow.png

 

5. Next, using a send email from a shared inbox action we send a confirmation email back to the submitter with details of what they submitted.

 

5-Flow.png

 

 6. Finally an email is sent to the scheme administrator and the manager of the nominee.

6-Flow.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@Rob Elliott this is a great suggestion! I'd go with this too with the scenario @DrishM has described.