I want to create a SharePoint Online (Office 365) survey based on the information from emails. But SharePoint Online survey cannot extract the information and create survey based on the emails. It seems that this can be achieved by creating a workflow with Microsoft Automate. As some uses can create new SharePoint list or list items when they receive an email. Then the workflow can extract the information based on the email content and create. I would like to know more about creating a flow with Power Automate. Any advice are really appreciated.
@Anonymous - I think there is additional information missing here. Do all the emails have a consistent body message? Or, are they all different/unique?
If they are all consistent, you could possibly parse the text from the email body to translate it into your needs (Parserr comes to mind - and there is a connector for Parserr and Power Automate). Then, you can take the parsed output to the Power Automate steps.
Another option to explore is Microsoft Forms Pro. It has triggers that can be built to send out the surveys. It integrates with other systems (obviously the Power Platform). You can then use Power Automate with Microsoft Forms Pro to automate whatever actions you need.
Hi PowerBack19, thank you very much. Actually, the subject line are not exactly consistent. For example, one is " HB Psy referral, Jeff, ID12345, efile", the other is " MB Review, Plan12, 23456, E-file", what I want to extract is ID # into the survey or form, i.e. 12345 ( first example) and 23456 ( second example). Is there a way to do get them with Power Automate?
Hi @Anonymous ,
If your ID is always at number 3 position, what you can do is use Split function with separator as ",". Then get the value in array and fetch the value.
If you want to see how this would work, take a look at my response on thread below.
Based on examples provided below, it would fetch "ID12345" and "23456". If you don't need ID in first case, you can replace using string functions.
Thanks. My ID number mostly in 3 position, but not absolute; also, I read the thread you posted before, it is for retrieving and parsing JSON that has a date/time in a string, seems not as what I am looking for. Would you provide more general approach or suggestion on my case? - J
@Anonymous - The reason for asking the additional question is that you can set up Trigger Conditions so that the flow doesn't run every time an email comes in (again, I'm not sure what you are monitoring to trigger the flow).
With Trigger Conditions, you can specify when the flow runs. Here is an article with more on this topic: https://www.timlinenterprises.com/microsoft-power-automate-flow-trigger-conditions/
If the subject line and/or email body were consistent, you could feed this to the Trigger Condition. Otherwise, the flow will have to run on every email and will need a Check Condition to continue the flow or terminate it. The issue with this approach is that you could eat up your flow capacity quickly if you aren't careful. Check out this article for information on API request limits: https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations#microsoft-power-platform-requests-allocations-based-on-licenses
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!