Hi everyone!
I hope that this is not a unique scenario and that someone has the answer!
So, I was thinking of using an InfoPath Web Form that is published to a Form Library in SharePoint Online to delivery a daily newsletter all of our staff. We currently use a 3rd party app in Office 365 to do this, but the app is flaky, unsupported and does not always send out the daily email. The daily email is to include new Announcements and upcoming Events and sign-up opportunities for staff.
I can get the form to send the email just fine. No problems there. The issue seems to be that the icon/image for each announcement in the email does not display unless you click on them individually. Could I find a way to get the images from this secondary data source repeating table to store the images in the form (instead of using the URL to the image). I think that somehow there needs to be a static view of this table. Is the data connection to get the data for the Announcements repeating table being run for each email recipient? I don't want that. I just want to run the data connection when I generate the form before I send it out by email through the send email data connection.
This image shows how the form looks in SharePoint Online before I click submit (send email data connection):
This image show how the form renders in Outlook after it has been submitted in SharePoint Online: