Solved

How can I include a repeating table in a SharePoint Designer 2007 e-mail notification?

Posted on 2011-03-23
3
1,190 Views
Last Modified: 2012-05-11
We are using SharePoint Designer 2007 to create workflows for a Windows SharePoint Services 3.0 form library. Our InfoPath forms are 2003-compatible. In a workflow, we would like to create an e-mail notification that includes form fields which are from a repeating table, but something is getting lost in the translation. In the e-mail, there are no line breaks between rows. We end up with a single row containing all the values for all of the fields in the repeating table. How can we force line breaks so that the repeating table resembles the one in the InfoPath form?
0
Comment
Question by:PJBluske
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 35201285
SharePoint does not support repeating elements, that is your issue.
Their hack is to make a delimited list of them but does not work very well.

Your best bet is to include a link to the form or attach the form.

Another option is to do the workflow within InfoPath, then you can email it as an attachment or convert a view to the email body.
0
 

Author Comment

by:PJBluske
ID: 35206585
This is a case where linking to the form or sending it as an attachment isn't practical. Being able to include the repeating table in a notification e-mail would mean fewer people accessing the actual form and therefore increased availability to those who need to modify it. I have seen references elsewhere suggesting that it is possible. At this point, I would even be interested in hearing more about the above-mentioned delimited list "hack."
0
 
LVL 28

Expert Comment

by:clayfox
ID: 35206765
Yah I totally understand.

If you generate the email from InfoPath, you have more options since the data is still in a repeating state.  You could have a custom email smtp and do whatever you wanted.

You could store the data in a database, which I would recommend anyway, since then you can do all sorts of reporting and aggregates and all of the repeating elements are preserved.

If you have to work with data in SharePoint then what you see is as good as you get or you have to create another list to store the repeating elements and try to link to them manually.

One have is to create your own additional field, and then in InfoPath manage is and concatenate the data into the way you might want to see it, with your own seperators.  Or if there is a finite amount or elements, allocate 10 fields and populate each one with a value from the first 10, etc.

You have just run into a design / architecture limitation with using SharePoint as the data repository.

you may be interested in the Database Accelerator tools www.qdabra.com has to offer.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question