New to Power Automate and need help with adaptive card multi selection to SharePoint list!!

[PANewbie99]

Hey everyone,

I apologise if this is not the correct place to post but looking for help with a flow.  I have created an adaptive card that at times will be required to have more than one user selected in a choice field.  The adaptive card is set up with a manual trigger, sent to a teams chat to be filled and then returns the information to a SharePoint list.  The process works perfectly when selecting one user, but fails when more than one user is selected to be assigned to a task in the SharePoint list. 

(I also have ensured the SharePoint list is set for multiple selections)

When looking at what the flow is sending to the 'Assigned to' column it looks like this for example "testemail1@generic.com.au,testemail2@generic.com.au".

I have tried using the replace function to send it to look like this "testemail1@generic.com.au","testemail2@generic.com.au".  But it looks like this in the raw output "testemail1@generic.com.au\",\"testemail2@generic.com.au"

As mentioned in the title, I am new to Power Automate and I can't find any solutions online and have spent way longer on this than I care to admit.  I'm not sure if this is even a possibility! 

Any advice or direction is welcomed.  

[v-yueyun-msft]

Hi , @PANewbie99 

Can you show where you put the multi selection person as choices in your adaptive card in your flow side? Can you give me a screenshot for your flow?

Best Regards,

Yueyun Zhang

[PANewbie99]

Hey @v-yueyun-msft ,

I hope what I am responding with is what you are asking for,  this is the adaptive card:

{

    "type": "AdaptiveCard",

    "body": [

        {

            "type": "Container",

            "minHeight": "200px",

            "backgroundImage": {

                "url": "https://th.bing.com/th/id/OIP.pioadtIyI5MapBKZrtWzWgHaEO?rs=1&pid=ImgDetMain"

            },

            "bleed": true,

            "verticalContentAlignment": "Bottom",

            "style": "attention",

            "items": [

                {

                    "type": "TextBlock",

                    "text": "Work Progress Tracker",

                    "size": "ExtraLarge",

                    "weight": "Bolder",

                    "color": "Attention",

                    "isSubtle": false,

                    "horizontalAlignment": "Center",

                    "style": "heading",

                    "spacing": "None",

                    "maxLines": 0,

                    "fontType": "Default"

                }

            ]

        },

        {

            "type": "Container",

            "bleed": true,

            "items": [

                {

                    "type": "Input.ChoiceSet",

                    "choices": [

                        {

                            "title": "Test Email 1",

                            "value": "Testemail1@generic.com.au"

                        },

                        {

                            "title": "Test Email 2",

                            "value": "Testemail2@generic.com.au"

                        },

                        {

                            "title": "Test Email 3",

                            "value": "Testemail3@generic.com.au"

                        },

                        {

                            "title": "Test Email 4",

                            "value": "Testemail4@generic.com.au"

                        },

                        {

                            "title": "Test Email 5",

                            "value": "Testemail4@generic.com.au"

                        }

                    ],

                    "placeholder": "Please choose a name from dropdown",

                    "id": "PeoplePickerID",

                    "label": "Assigned to",

                    "isRequired": true,

                    "errorMessage": "*required",

                    "isMultiSelect": true,

                    "spacing": "None"

                },

                {

                    "type": "Input.Text",

                    "spacing": "Small",

                    "id": "Task Name ID",

                    "placeholder": "Name of Task",

                    "isRequired": true,

                    "errorMessage": "*required",

                    "label": "Project/Task Name"

                },

                {

                    "type": "Input.Text",

                    "placeholder": "Please add a description of task",

                    "id": "Description ID",

                    "isMultiline": true,

                    "isRequired": true,

                    "errorMessage": "*required",

                    "label": "Description"

                }

            ]

        },

        {

            "type": "Input.ChoiceSet",

            "choices": [

                {

                    "title": "SharePoint Hubs",

                    "value": "SharePoint Hubs"

                },

                {

                    "title": "Communications",

                    "value": "Communications"

                },

                {

                    "title": "Project Build",

                    "value": "Project Build"

                },

                {

                    "title": "Support Request",

                    "value": "Support Request"

                },

                {

                    "title": "Administration",

                    "value": "Administration"

                },

                {

                    "title": "Other",

                    "value": "Other"

                }

            ],

            "placeholder": "Please select Category",

            "id": "Cat ID",

            "isRequired": true,

            "errorMessage": "*required",

            "label": "Category"

        },

        {

            "type": "Input.ChoiceSet",

            "choices": [

                {

                    "title": "Build Update",

                    "value": "Build Update"

                },

                {

                    "title": "Hub Build",

                    "value": "Hub Build"

                },

                {

                    "title": "Power Automate",

                    "value": "Power Automate"

                },

                {

                    "title": "SharePoint List",

                    "value": "SharePoint List"

                },

                {

                    "title": "Reporting",

                    "value": "Reporting"

                },

                {

                    "title": "Other",

                    "value": "Other"

                }

            ],

            "placeholder": "Please select your Subcategory",

            "id": "SubCat ID",

            "isRequired": true,

            "errorMessage": "*required",

            "label": "Subcategory"

        },

        {

            "type": "Input.ChoiceSet",

            "choices": [

                {

                    "title": "Not Started",

                    "value": "Not started"

                },

                {

                    "title": "In Progress",

                    "value": "In progress"

                },

                {

                    "title": "Completed",

                    "value": "Completed"

                },

                {

                    "title": "On Hold",

                    "value": "On Hold"

                }

            ],

            "placeholder": "Please select relevant progress",

            "id": "Progress ID",

            "errorMessage": "*required",

            "isRequired": true,

            "label": "Progress"

        },

        {

            "type": "Input.ChoiceSet",

            "choices": [

                {

                    "title": "High",

                    "value": "High"

                },

                {

                    "title": "Medium",

                    "value": "Medium"

                },

                {

                    "title": "Low",

                    "value": "Low"

                }

            ],

            "placeholder": "Please select priority",

            "id": "Work Priority ID",

            "isRequired": true,

            "errorMessage": "*required",

            "label": "Priority"

        },

        {

            "type": "ColumnSet",

            "columns": [

                {

                    "type": "Column",

                    "width": "stretch",

                    "items": [

                        {

                            "type": "Input.Date",

                            "spacing": "Small",

                            "id": "Start-date",

                            "isRequired": true,

                            "errorMessage": "*required",

                            "label": "Start Date"

                        }

                    ]

                },

                {

                    "type": "Column",

                    "width": "stretch",

                    "items": [

                        {

                            "type": "Input.Date",

                            "spacing": "Small",

                            "id": "Due-date",

                            "isRequired": true,

                            "errorMessage": "*required",

                            "label": "Due Date"

                        }

                    ]

                }

            ]

        },

        {

            "type": "ActionSet",

            "actions": [

                {

                    "type": "Action.Submit",

                    "title": "Submit",

                    "style": "positive"

                }

            ],

            "id": "Submit"

        }

    ],

    "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",

    "version": "1.4"

}

[v-yueyun-msft]

Hi , @PANewbie99 
Thanks for your response! Do you mean you want to get the response from your adaptive card choices selection and create an item to SharePoint list(Multiple-Selected person column)?

Best Regards,

Yueyun Zhang

[PANewbie99]

Hey @v-yueyun-msft ,

Yes thats correct.  It will work with one person selected, but wont with more than one. 

[v-yueyun-msft]

Hi , @PANewbie99 

Thanks for your response! 

First , if you want to create the multiple-select person column, you need to pass:

[{"Claims":"xxxxxxxxx"},{"Claims":"xxxxxxxxx"}]

Solved: Update a person field in sharePoint with multiple ... - Power Platform Community (microsoft....

I test it in my side , this is the output of my "Post adaptive card and wait for a response" action:

If you want to add this to the Multiple Person Column, you can refer to my test flow:

split( outputs('Post_adaptive_card_and_wait_for_a_response')?['body/data/peoplePickerID'] , ',')

concat('i:0#.f|membership|' , toLower(item()))

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[PANewbie99]

Hi @v-yueyun-msft 

Unfortunately, I am not having much luck.  I have followed the above but when I go and add to the 'output' on the 'create item' I only have 'output item'.  The flow then proceeds to add a 'for each' and changes the claims to the 'for each'.  I am not sure what I am doing wrong 😞

[v-yueyun-msft · Accepted solution]

Hi , @PANewbie99 

Thanks for your response!

You need to Select the "Output" of Select action like this:

You need to first click the icon behind it . And then select the "Output". You can also convert to the classic mode to test:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[PANewbie99]

Hey @v-yueyun-msft,

Thank you so much, I changed it back to the old designer and it worked. 

I appreciate your help on this and hope to be as great at Power Automate as you are one day!!

Thanks again 🙂

[faadhil]

Bonjour à tous.
Je rencontre un problème avec un des flux que je construis. Il a pour but de dézipper des fichiers de type zip contenus dans un dossier tout en les déplaçant vers un autre dossier dès que de nouveaux fichiers sont créés dans le dossier. 

 
Tout le flux fonctionne, les fichiers sont bien récupérés et recopiés dans leur dossier de destination, mais ils ne sont pas dézippés, alors que lors des tests, je n'ai aucun problème : le flux fonctionne entièrement, sauf que les fichiers ne sont pas extraits comme ils devraient l'être.  

Si vous avez déjà eu des cas similaires ou alors vous savez ce qui pose problème je vous serai reconnaissant de bien vouloir m'aider à résoudre ce problème 
Merci d'avance pour votre aide.