Daily summary email from SharePoint with choice field

[smorley]

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.

[Hardesh15 · Accepted solution]

@smorley 

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

[smorley]

@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?

[Hardesh15]

@smorley 

Add above your Apply to each action. DO not include in either yes/no block otherwise it will create loop inside loop.

Thanks

Hardesh

[smorley]

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.

[smorley]

Here's what it looks like with the Selected room value.

[Hardesh15]

@smorley 

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

[smorley]

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.

 

[Hardesh15]

@smorley 

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

[smorley]

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.

 

 

 

 

[Hardesh15]

@smorley 

Please Share Output of the previous execution.

Thanks

Hardesh

[smorley]

That part is easy @Hardesh15 at least.

 

[Hardesh15]

@smorley 

Please verify this in SharePoint list. You are getting selected Room Value but it is appending to previous value as well.

Thanks

Hardesh

[smorley]

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.

[smorley]

@Hardesh15 - just back from vacation.  Any new thoughts?