PowerApps Track Email with Logic Flows

PowerApps brings with it the ability to create a “Logic Flow“, which in reality allows for cloud services to be connected, consumed easily and perform tasks that otherwise would have taken a whole bunch of code to work.

Once such task would be the inability to perform incoming email like SharePoint On-Premises does. This can be remedied by using a “Logic Flow” in PowerApps.

To create a “Logic Flow” in PowerApps, we need to be in the PowerApps Web site and choose the “Create a Logic flow” link.

This takes us to the screen where we can pick from pre-defined flows.

The one we want to use is the “Track emails in a SharePoint list“.

The idea here is that we would monitor the Office 365 mailbox for new emails and then save them into a SharePoint List as a reference, not quite full incoming email but a start. To get started we need to create the connection to the Office 365 mailbox we wish to use. In my connections list I have two connections to different mailboxes as well as the OneDrive and Twitter one from before.

Within the “Logic Flow“, we need to specify the connection for the “On new email” action.

For this I am selecting the one called “incomingemail“. Once the connection is set we can then set properties for the connections and parameters that filter the emails that we process.

I have set mine to the following:

Now we need to set the connection details for the SharePoint List.

Once the SharePoint Online connection you can select the site collection and list that you wish store the emails.

The next step is to choose the incoming email properties that you wish to use as the “Title” fields in the list.

Now have everything mapped together we can save this “Logic Flow” with a name and it will then publish it into your PowerApps configuration. Once saved it will be listed in the “Logic Flows” screen and also you can “Disable” it from working as needed, edit or delete as needed.

Sending an email to the mailbox should then kick off the “Logic Flow” and the mail should be saved directly into SharePoint using this flow.

Now we wait and see if the process kicks off, grabbing the email sent, and saves a reference to the email, albeit just the “from” field. Now you could of course capture more details as needed.

Each “Logic Flow” has a list of failures and successes that can be accessed from the flow itself.

Then each row can be clicked into to give you some very basic, did it pass or fail values.

Each “Logic Flow” can contain multiple actions and also conditions, to create some very complex flows that interest with multiple systems.

We also have the ability to associate “Logic Flows” to PowerApps that we have created, so as an example we could use the contact application from before and as soon as a new contact is added, have it email us then store values in SharePoint or some other cloud service, bringing all of them together in a cohesive solution.

Liam Cleary

Liam began his career as a Trainer of all things computer related. He quickly realized that programming, breaking, and hacking was a lot more fun. He spent the next few years working within core infrastructure and security services until he found SharePoint. He is the founder and owner of SharePlicity, a consulting company that focuses on all areas of Technology. His role within SharePlicity is to help organizations implement technology that will enhance internal and external collaboration, document and records management, automate business processes and of course security controls and protection. Liam also serves as the Product Owner for Security at Rencore, where he is helping to develop offerings that help organizations further understand and mitigate security and compliance risks, within SharePoint and Office 365 customizations. His core focus will is to identify, control and protect whether they are full-fledged customizations or out-of-the-box Office 365 functionality. He is also a twelve-time Microsoft MVP focusing on Architecture but also crosses the boundary into Development. His specialty over the past few years has been security in SharePoint and its surrounding platforms. He can often be found at user groups or conferences speaking, offering advice, spending time in the community, teaching his kids how to code, raspberry PI programming, hacking the planet or building Lego robots.

You may also like...