Event registration and welcome email with flow/powerapps?

%3CLINGO-SUB%20id%3D%22lingo-sub-159908%22%20slang%3D%22en-US%22%3EEvent%20registration%20and%20welcome%20email%20with%20flow%2Fpowerapps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159908%22%20slang%3D%22en-US%22%3E%3CP%3ESince%20Iam%20not%20a%20programmer%2C%20I%20have%20trouble%20coming%20up%20with%20a%20solution%20for%20the%20following%20scenario%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20s%20customized%20sharepoint%20list%20with%20a)%20the%20invited%20people%20(Office365%20account%20name%20as%20column)%20and%20b)%20a%20checkbox%20column%20to%20mark%20those%20people%20who%20will%20actually%20attend%20the%20event.%3C%2FP%3E%0A%3CP%3EBased%20on%20that%20I%20created%20a%20powerapp%20that%20lets%20me%20mark%20the%20checkbox%20during%20the%20reception%20of%20the%20event.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20this%20marking%20persons%20as%20checked%20in%20to%20the%20event%20should%20trigger%20a%20welcome%20email%20to%20each%20marked%20attendee%20with%20a%20welcome%20message%20and%20a%20link%20to%20the%20event%20programme%20(will%20be%20made%20available%20via%20sharepoint%20aswell).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20my%20biggest%20issue%20is%20coming%20up%20with%20the%20flow%20%22formula%22.%20Since%20I%20don't%20have%20any%20programming%20experinces%2C%20I%20am%20quite%20helpless%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-159908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211180%22%20slang%3D%22en-US%22%3ERe%3A%20Event%20registration%20and%20welcome%20email%20with%20flow%2Fpowerapps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211180%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15489%22%20target%3D%22_blank%22%3E%40Rebekka%20Aalbers-de%20Jong%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewow%20-%20thanks%20for%20this%20long%20reply%20%3A-).%20I%20will%20try%20to%20figure%20out%20the%20seconf%20option%20you%20mentioned.%20If%20it%20works%2C%20I%20will%20post%20it%20here.%20Thanks%20so%20much%20again%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211103%22%20slang%3D%22en-US%22%3ERe%3A%20Event%20registration%20and%20welcome%20email%20with%20flow%2Fpowerapps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211103%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15358%22%20target%3D%22_blank%22%3E%40Benedikt%20Scheerer%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20you%20posted%20this%20question%20ages%20ago.%20Just%20stumbled%20up%20to%20it.%20Hope%20you%20still%20benefit%20from%20an%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20several%20things%20you%20could%20do%20in%20the%20scenario%20you%20describe%2C%3C%2FP%3E%3CP%3EYou%20could%26nbsp%3Btrigger%20a%20Flow%20sending%20the%20e-mail%26nbsp%3Bbut%20you%20could%20also%20directly%20send%20the%20email%20through%20an%20action%20in%20PowerApps%20with%20the%20Office%20365%20Outlook%20connector.%3C%2FP%3E%3CP%3EI%20kind%20of%20prefer%20Flow%20in%20scenario's%20like%20this%2C%20since%26nbsp%3Bit%20provides%20you%20with%20the%20run%20history%20out%20of%20the%20box.%3C%2FP%3E%3CP%3EWhen%20you%20use%20Flow%20you%20again%20have%20several%20options%20in%20what%20you%20use%20to%20trigger%20the%20Flow.%20You%20could%20use%20the%20update%20on%20the%20SharePoint-list%20as%20a%20trigger%2C%20but%20that%20would%20be%20the%20more%20complex%20approach%20because%20you%20would%20have%20to%20add%20some%20logic%20to%20determine%20the%20exact%20update%20(the%20marking%20of%20the%20checkbox)%20that%20should%20result%20in%20the%20sending%20of%20the%20email.%3C%2FP%3E%3CP%3EIn%20this%20case%20I%20would%20use%20the%20PowerApps%20connector%20in%20Flow%20to%20trigger%20the%20Flow%20based%20on%20an%20action%20in%20your%20PowerApp.%20You%20could%20ad%20an%20action%20to%20the%20oncheck%20property%20of%20your%20checkbox%20in%20PowerApps%20to%20run%20your%20Flow%26nbsp%3Band%20pass%20through%26nbsp%3Bto%20the%20Flow%20the%20information%20of%20the%20item%20and%20the%20user%20you%20want%20to%20send%20the%20email%20to.%20The%20email%20content%20you%20can%20define%20within%20your%20Flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20this%20works%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563803%22%20slang%3D%22en-US%22%3ERe%3A%20Event%20registration%20and%20welcome%20email%20with%20flow%2Fpowerapps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15358%22%20target%3D%22_blank%22%3E%40Benedikt%20Scheerer%3C%2FA%3E%26nbsp%3BHey%20there%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15358%22%20target%3D%22_blank%22%3E%40Benedikt%20Scheerer%3C%2FA%3E%26nbsp%3B%20--%20I%20could%20certainly%26nbsp%3B%20use%20a%20similar%20solution.%26nbsp%3B%20If%20you%20were%20able%20to%20get%20it%20working%2C%20would%20you%20be%20willing%20to%20share%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Since Iam not a programmer, I have trouble coming up with a solution for the following scenario:

 

I have s customized sharepoint list with a) the invited people (Office365 account name as column) and b) a checkbox column to mark those people who will actually attend the event.

Based on that I created a powerapp that lets me mark the checkbox during the reception of the event.

 

Now this marking persons as checked in to the event should trigger a welcome email to each marked attendee with a welcome message and a link to the event programme (will be made available via sharepoint aswell).

 

So my biggest issue is coming up with the flow "formula". Since I don't have any programming experinces, I am quite helpless :)

3 Replies

Hi @Benedikt Scheerer,

 

I see you posted this question ages ago. Just stumbled up to it. Hope you still benefit from an answer.

 

There are several things you could do in the scenario you describe,

You could trigger a Flow sending the e-mail but you could also directly send the email through an action in PowerApps with the Office 365 Outlook connector.

I kind of prefer Flow in scenario's like this, since it provides you with the run history out of the box.

When you use Flow you again have several options in what you use to trigger the Flow. You could use the update on the SharePoint-list as a trigger, but that would be the more complex approach because you would have to add some logic to determine the exact update (the marking of the checkbox) that should result in the sending of the email.

In this case I would use the PowerApps connector in Flow to trigger the Flow based on an action in your PowerApp. You could ad an action to the oncheck property of your checkbox in PowerApps to run your Flow and pass through to the Flow the information of the item and the user you want to send the email to. The email content you can define within your Flow.

 

Let me know if this works for you.

 

Hi @Rebekka Aalbers-de Jong,

 

wow - thanks for this long reply :-). I will try to figure out the seconf option you mentioned. If it works, I will post it here. Thanks so much again for your help.

@Benedikt Scheerer Hey there, @Benedikt Scheerer  -- I could certainly  use a similar solution.  If you were able to get it working, would you be willing to share it? 

 

Thanks!