Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Update Multi Choice column values from form

(0) ShareShare
ReportReport
Posted on by
I have a SharePoint list with the fields EmpName, Manager, and AppsRequired. The AppsRequired column is a choice column that may take several values. Essentially, it includes a list of application names.
When a new item is created with EmpName, Manager, send an email to the manager asking the application for the new employee. Once the manager has chosen an application, the data should be saved back to the list.
Can we accomplish this by distributing a simple form or through an approval email flow?
  • Suggested answer
    David_MA Profile Picture
    David_MA 8,950 on at
    Update Multi Choice column values from form
    You could create an adaptive card and send it to the manager through a Teams message. This would allow for the option to choose multiple items. Although, it would be much easier to just send the link to the item and ask the manager to choose the options. You can have the flow trigger when the item is updated, and use the check for changes action to see if the field has been modified.
     
    If you go the adaptive card route, this is an example of the code for an adaptive card:
     
    {
        "type": "AdaptiveCard",
        "body": [
            {
                "type": "TextBlock",
                "text": "What apps are required?",
                "weight": "Bolder",
                "size": "Medium"
            },
            {
                "type": "Input.ChoiceSet",
                "id": "requiredApps",
                "style": "expanded",
                "isMultiSelect": true,
                "choices": [
                    {
                        "title": "Acrobat",
                        "value": "acrobat"
                    },
                    {
                        "title": "Word",
                        "value": "word"
                    },
                    {
                        "title": "Excel",
                        "value": "excel"
                    },
                    {
                        "title": "PowerPoint",
                        "value": "powerpoint"
                    },
                    {
                        "title": "OneNote",
                        "value": "onenote"
                    }
                ]
            }
        ],
        "actions": [
            {
                "type": "Action.Submit",
                "title": "Submit"
            }
        ],
        "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
        "version": "1.3"
    }
     
    It produces this:
     
    Here is a demo on the basics of using an adaptive card: https://youtu.be/LAOVAr5GP84?si=P0AdmVuzmlFtOI5r

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard