New to this Community, and hoping someone out there can help me.
I have about 20+ SharePoint 2010 Workflows creating pre-formatted emails, with the email content data being inputted via forms I have created in InfoPath. Before you say it, yes I know that both of these are now very old products and I need to move away from them. Unfortunately my company is still reluctant to adopt PowerApps, so replacement forms I have started to build using this are not available to anyone yet.
My immediate problem is that SharePoint 2010 Workflows are due to be deprecated in November. I have been frantically replicating my workflows in Power Automate (PA).
I have come across a problem displaying the output of an InfoPath 'Repeating Table' in an email created in PA. The email Body is simple HTML code.
In the following example I have created 4x lines in my Repeating Table, in InfoPath. When I submit the data an XML Form is created in my SharePoint Form library. This then triggers the workflow to run and send out an email.
Using the SharePoint Workflow, the email 'sender' is the SharePoint site. In Power Automate, I have created a new 'Shared' Email address, which appears to work fine.
Here is my data in the form:
Here is how the old SharePoint Workflow would display the repeating table data in the email:
This is the same data displayed in an email created by Power Automate
How do I get Power Automate to replicate the SharePoint email, with the data displayed line by line? The html code is identical in both workflows, other than being presented nicer in PA.
Original html code in Sharepoint Workflow
Replicated code in Power Automate
The data options of what you can publish out of InfoPath are limited. I have always used the 'merge' option to combine all of my data.
I just need to keep these forms running for another year, whilst a colleague can rebuild them on a website. Ideally I do not want to have to completely redesign my InfoPath form, unless there is a simple solution, as time is limited. I am hoping that there is another solution in Power Automate that can correctly format my existing data how I want it.
Thanks in advance
@Rob_J - Email formatting in Power Automate works differently. Rather than HTML tags you need to use markups. Refer Link below, how to format tables.
Here is the extract..
Organize structured data with tables.
Like and Mark this as answer if it resolves your issue.
The syntax to build tables using markdown seams quite straight forward, but how do I add this into my email body being created by Power Automate? My current emails use the HTML tags, when using 'Code View'. Is there a similar DOCTYPE statement I need to add to indicate the use of Markdown?
@Rob_J - No. Its not going to be HTML. Just type the markups in the body of the action. Format entire body using Markup stags.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.