Newbie Questions

Re: Having trouble formatting repeating table info in an email

quickshot23 — Tue, 17 Sep 2019 17:49:22 GMT

That did it! Thank you so much for your help Stephen Ebling

Re: Having trouble formatting repeating table info in an email

Hilary Stoupa — Tue, 17 Sep 2019 17:25:00 GMT

I'd get rid of the two fields for qty and x. Instead I'd add a field in the repeating table that concats the info together the way you want it, then apply the eval to that. See attached - save locally, right click and select design to preview and see the changes I made.

Re: Having trouble formatting repeating table info in an email

quickshot23 — Tue, 17 Sep 2019 17:08:42 GMT

Form attached:

Re: Having trouble formatting repeating table info in an email

Hilary Stoupa — Tue, 17 Sep 2019 16:15:31 GMT

May I see your latest form?

Re: Having trouble formatting repeating table info in an email

quickshot23 — Tue, 17 Sep 2019 15:42:55 GMT

The field on the form shows the spaces:

Re: Having trouble formatting repeating table info in an email

Hilary Stoupa — Tue, 17 Sep 2019 15:21:44 GMT

I'm not sure. Is this the same result you see in the form in the field? That is, if you put the log field on the form (or look at the submitted XML in notepad, or look at the value in the promoted field) is the space there? My initial guess is that it is somewhere in the form logic, but it doesn't seem like any of these are set via rules.

Re: Having trouble formatting repeating table info in an email

quickshot23 — Tue, 17 Sep 2019 14:44:57 GMT

It seems that a space is added after each user-entered field for the first row ie. after "BBQ" and after "2"

Re: Having trouble formatting repeating table info in an email

quickshot23 — Tue, 17 Sep 2019 14:00:51 GMT

I added an extra static field to show the x

Re: Having trouble formatting repeating table info in an email

Hilary Stoupa — Mon, 16 Sep 2019 19:53:21 GMT

Yeah, that's odd. Is the "x" something that is typed in? Or is there a rule adding that?

Re: Having trouble formatting repeating table info in an email

quickshot23 — Mon, 16 Sep 2019 18:58:27 GMT

Also, it is showing the space on the field31 of the form. So it has to be infopath that is causing this. Thank you Stephen Ebling

Re: Having trouble formatting repeating table info in an email

quickshot23 — Mon, 16 Sep 2019 18:55:50 GMT

I do have one quick question - If you look at my email that I received (screenshot above) You will see a space after 20000 - FP Halves for BBQ - Qty: 2(Space)x The other lines do not have this. Why does the first entry insert a space that the others do not? Is there a way to make it not do that? Thank you again Stephen Ebling

Re: Having trouble formatting repeating table info in an email

quickshot23 — Mon, 16 Sep 2019 18:53:10 GMT

Hello Hilary, Your idea with an HTML break worked perfectly. I added
in the rule and it worked perfectly. I am attaching 2 screenshots if you are curious what I did (or if it can be helpful to another user) Thank you so much! God Bless Stephen Ebling

Re: Having trouble formatting repeating table info in an email

Hilary Stoupa — Mon, 16 Sep 2019 17:56:54 GMT

So - I'd probably put field 31 on the form, add a test button, and set field 31 the way you want (i.e., using the character return) and make sure the data looks the way you want. Then you could check if SharePoint Designer is the culprit. You could also test with MS Flow, if you have access, since it looks like you are using SharePoint Online - you may have better luck with it respecting your new lines. Or, you could leave the double eval with the pipe and look into whether you can use a replace function in SharePoint Designer to replace the pipe with an HTML break, for example - MS Flow has the substitute function that may also help you with that if you decide to try Flow....

Re: Having trouble formatting repeating table info in an email

quickshot23 — Mon, 16 Sep 2019 17:05:56 GMT

I obviously made changes Here is a screenshot of the output currently (See attached) Ideally, I would want each line (group) from the form to have its own line

Re: Having trouble formatting repeating table info in an email

quickshot23 — Mon, 16 Sep 2019 17:02:48 GMT

Form attached