cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

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
Super User II
Super User II

@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
Super User II
Super User II

@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

@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

@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

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.

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

appendwithvalue.jpg

@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

 

 

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

@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

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

@smorley 

 

Please Share Output of the previous execution.

 

Thanks

Hardesh

That part is easy @Hardesh15 at least.

 

emailoutput.jpg

@smorley 

 

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.

appendingvaluestwice.jpg

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

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (52,039)