Forum Discussion

DrishM's avatar
DrishM
Copper Contributor
Dec 08, 2020
Solved

SharePoint List

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 hav...
  • RobElliott's avatar
    RobElliott
    Dec 09, 2020

    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.


     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.

     

    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.

     

    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.

     

    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.

     

     

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

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources