Power Platform Community Forum Thread Details

There's a few notes to clarify first.

My current flow is a simple flow that pushes microsoft forms response data to sharepoint list. I currently just have:

"When a New Response is Triggered" --> "Get Response Details" --> "Create Item"

One of the questions for the survey is asking people to select their relevant shops in a multiple choice format where more than 1 answer can be provided.

For example:

Q: "Please select your shops"

1. Shop1 | ShopID1

2. Shop2 | ShopID2

3. Shop3 | ShopID3

The respondent could then select option 1 and 3, yielding ['Shop1 | ShopID1', 'Shop3 | ShopID3'].

My target answer is to retrieve the shop codes only: ['ShopID1', 'ShopID3'] and store it in my sharepoint list column "Shop ID". It is OK for there to be multiple Shop IDs in a single row.

I have tried to write an expression in the advanced parametres section for the Shop ID field of the Create Item step. I initally tried using the Last function to retrieve the shopID only of each response and then concatenating the IDs together afterwards but it did not work.

Could I please get some assistance on this? Thank you.

Categories:

Building flows