SharePoint Integration

Re: Repeating Table Info Into E-mail

Stuart Shutts — Tue, 05 May 2020 16:34:10 GMT

(email below)

The Weekly Productivity Tracker has been submitted for Stuart.Shutts@va.gov.

The Dates covered are: 4/27/2020 to 5/1/2020.

Total Hours reported is: 40.75

Activity for the Period (format: Activity-Description-Time in Hours) is:
No : Richmond SP Work - Remove Name from Conf room, then test why Diane F was getting weird emails - .5
No : Richmond SP Work - Modify SOP - .25
No : Richmond SP Work - Export/Delete files from HCHV site, prep for migration - 1
No : VISN 6 Office SP Work - A3 Grading form Testing - 1.5
No : VISN 6 Office SP Work - Grade Black Belt A3 - 1
No : VISN 6 Office SP Work - Redo Visn 6 A3 WF Variables - 1
No : Other Sharepoint Work - IAA Project Grading Form Work - 5
No : Meetings/Conference Calls - go over some basic SP Maintenance - 4
No : Meetings/Conference Calls - VISN 6 DLO Innovation site - .75
No : Meetings/Conference Calls - Wichita SR, discuss Veteran Transport Site - 1
No : Meetings/Conference Calls - SP Duties - 1
No : Meetings/Conference Calls - MSFT SPO Meeting - 1
No : Meetings/Conference Calls - SPO Questions and PA WF issues - 2
No : Meetings/Conference Calls - Script Editor Banner Webpart Training - 1
No : Meetings/Conference Calls - Go over her Data Connections - 1
No : Meetings/Conference Calls - -skype-diagnose Fayetteville Infopath data connections - .5
No : Meetings/Conference Calls - , Virtual YB Discussion - 1
No : Meetings/Conference Calls - Training SP - 4
No : Meetings/Conference Calls - Person Redacted - .25
No : Meetings/Conference Calls - , look at process moving to SPO and see what solutions could be presented - .75
No : Meetings/Conference Calls - Salsibury Infopath form broken upload, OT - .75
No : Meetings/Conference Calls - Salisbury, uploaded more recent CPR 2020 form from laptop - .5
No : Meetings/Conference Calls - Review SOP layout - 1
No : Meetings/Conference Calls - IAA FY 21 Grading Form - 1
No : Meetings/Conference Calls - SPO Overview - .5
No : Meetings/Conference Calls - Discuss HCHV Migration to new Secure Site - .5
No : Other - Answer emails/Phone/Skype - 4
No : Other - Reboot/update computer during working hours - .5
No : Leave - 4-27-20 1 hour of expiring travel comp time - 1
No : Break - Break - 2.5

i concat a field in the form like this: concat(Highlight, " : ", Activity, " - ", Activity_Details, " - ", Number_of_Hours) [This is a hidden field on the repeating table and as such it acts like the email shown above]

I create a multi-line text field on Sharepoint, promote it as a merged field, and then send the merged field in the email.

Re: Repeating Table Info Into E-mail

Hilary Stoupa — Fri, 27 Mar 2020 22:29:45 GMT

When I view source on the sample email that you sent me, I can see that the Time Zones aren't in td elements. So, I'd guess on your HTML String, you've missed an opening and closing (or maybe just one or the other?) td elements around the time zone fields. Can you check that?

Re: Repeating Table Info Into E-mail

dapklp — Fri, 27 Mar 2020 17:46:54 GMT

Success! (screen shot of the table in the e-mail)

I would like to make a couple of modifications though. The last column doesn't seem to separate the rows like the first 2 columns and I'd like some buffer space after the longest Location Address (to improve readability). Spacing is fine between the first 2 columns. I usually don't create header and body variables for e-mails, but I followed the example provided by Kaoru in her demo. Here are my results:

Header variable: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><html><head><style type="text/css"> h3,p,tr,td {font-family:'Verdana';line-height:1.25;} td { border-color:#e0e0e0; padding: 2px 5px;} th {background:rgb(231, 235, 240); border-color:#e0e0e0; border-bottom:1px solid #abb8bd; padding: 2px 5px; font-style:italic;} a { color:#b61234; text-decoration:none; } a:visited { color:#b10069; }</style></head><body>

Detail variable: <p><b>Detail</b></p><table border="1" style="margin-left:20px;border-collapse:collapse;border:1px solid #e0e0e0"><tr><th>Agent ID</th><th>Location Address</th><th>Time Zone</th></tr>[HTMLstring]</table>

Here is the properties String Builder for Body associated with the e-mail (screen shot):

DAP

Re: Repeating Table Info Into E-mail

Hilary Stoupa — Fri, 20 Mar 2020 15:28:53 GMT

Have you seen this webinar video? It might help you, and has a link to a kit you can download that should have some additional materials: https://www.youtube.com/watch?v=Wof2n9RHU5w

Repeating Table Info Into E-mail

dapklp — Thu, 19 Mar 2020 12:24:27 GMT

I have 3 columns in a repeating table (Agent ID, Location, Time Zone). Most forms will only have 1 or 2 entries (rows), but some may have 20. I imagine I’ll have to copy all of the information into another field (concatenated somehow) which I then promote to the document library and then somehow convert it using SP Designer so that it ends up looking like this in an e-mail:

AB123C 123 Somewhere, TX 77071 Central

12XYZZ 456 Somewhere Else, ME 96999 Eastern

I found 2 other posts that discussed this, but didn't understand what was going on in either. I am not a programmer. Thank you for any assistance you can provide.