Hi everyone, Happy Friday!
So far this week I've received help from @Hardesh15 and @ChristianAbata
All their help has been great.
Now I'm adding more complexity to my flow. It's similar to a solution that @MattWeston365 had last year regarding a Multiple Selection Column
I have a SharePoint list with a choice field called "Select Room"
Choices: a, b, c, d, e Multiple choices are allowed.
At a high level, my flow looks like this:
I've created a string variable for my room choice.
Inside the "Apply to Each" step it currently looks like this:
Then, outside the "Apply to Each" step is "Compose", and then "Send Email".
Finally, this is what the email currently looks like:
I need to figure out is how to set my variable for the room each time it loops through and does the append so the room selected gets populated.
Any assistance would be, as always, greatly appreciated.
Solved! Go to Solution.
Try this-
Use append to string variable and select your variable "Room Choice" and then in value select Room Choice value from Dynamic content. it will automatically set apply to each for multiple choice values.
In This way you will have all room choices in your variable.
Thanks
Hardesh
Try this-
Use append to string variable and select your variable "Room Choice" and then in value select Room Choice value from Dynamic content. it will automatically set apply to each for multiple choice values.
In This way you will have all room choices in your variable.
Thanks
Hardesh
@Hardesh15 - I thought that was the right tactic to use.
Would it go inside my If yes statement in my Flow, and if so would it go before the Append statement I already have?
Add above your Apply to each action. DO not include in either yes/no block otherwise it will create loop inside loop.
Thanks
Hardesh
Almost @Hardesh15
It's "Selected Room", not "Selected Room value"
Here's what the email looks like.
It does look like it's looping and adding all the rooms for the one item displayed. Rooms displayed are N473, N467, N472 and that's not the room for this item.
Here's what it looks like with the Selected room value.
Choose Selected Room Value but you need to include Append to string variable where you are filtering your line item. I have seen you are using get items that is why it is giving you all values irrespective of line item.
From your flow screens, you should use it this in YES block.
Thanks
Hardesh
I'm not sure what you mean @Hardesh15
Should I not use "Get items"? I'm not filtering on it.
This is what it looks like when I add Append to String variable for my selected room.
It's just after I initialize the Room Choice Variable, and before the main Apply to each action. You can see it creates another Apply to each action inside the append statement.
There is nothing wrong in your logic or actions. Only you are not getting where to use Append to String variable for Selected Room.
See your flow where you used Append to string Variable for Room Choices. After this use Append to String variable for Selected Room which should be under YES block. You need selected rooms for Start date greater than Today if i understand it correctly.
Thanks
Hardesh
I'm sorry for being such a bother @Hardesh15
Still displaying the same way in the email. I've put the Append action within the Yes condition.
Here's the screen shots with numbering. Maybe point out to me where in the number sequence I should put this append action.
Please verify this in SharePoint list. You are getting selected Room Value but it is appending to previous value as well.
Thanks
Hardesh
Definitely appending @Hardesh15 , the SharePoint list is fine. the entry for myDal Test account is now near the bottom of the list in the email, and the room at the end "Necropsy Station 1" is correct. The rooms before it are appending from all the ones in the list above it.
The bottom two items in the email should be room 472.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
89 | |
57 | |
40 | |
39 | |
35 |
User | Count |
---|---|
79 | |
66 | |
57 | |
52 | |
42 |