cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Daily summary email from SharePoint with choice field

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:

newhighlevel.jpg

I've created a string variable for my room choice.

 

Inside the "Apply to Each" step it currently looks like this:

Applytoeachstep1.jpg

smorley_0-1595589252365.png

Then, outside the "Apply to Each" step is "Compose", and then "Send Email".

compose.jpg

sendemail.jpg

Finally, this is what the email currently looks like:

emailoutput.jpg

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

@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

View solution in original post

14 REPLIES 14
Highlighted
Super User
Super User

@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

View solution in original post

Highlighted

@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?ifyes.jpg

Highlighted

@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

Highlighted

Almost @Hardesh15 

selectedroomappend.jpg

It's "Selected Room", not "Selected Room value"
Here's what the email looks like.
emailwithroomnotvalue.jpg

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.

Highlighted

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

appendwithvalue.jpg

Highlighted

@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

 

 

Highlighted

I'm not sure what you mean @Hardesh15 

Should I not use "Get items"?  I'm not filtering on it.

getitems.jpg

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.

appendtostringforroomselected.jpg

Highlighted

@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

Highlighted

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.

selectedroomvariable.jpg

yescondition.jpg

appendactions.jpg

sendemailfriday.jpg

Highlighted

@smorley 

 

Please Share Output of the previous execution.

 

Thanks

Hardesh

Highlighted

That part is easy @Hardesh15 at least.

 

emailoutput.jpg

Highlighted

@smorley 

 

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

 

Thanks

Hardesh

Highlighted

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.

appendingvaluestwice.jpg

The bottom two items in the email should be room 472.

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (9,443)