Hi, I currently have a list with a form and workflow. The list form has a people picker that allows for multiple selections, but only allows our internal emails. The workflow sends an email to all of these people. We would like to start including external users on the email. I thought that maybe I could use the email field that is available in the form designer, but that only allows for one selection and we need it to be a dynamic number of users. Will I have to create multiple fields and not be dynamic? Is there anything else I can do instead?
Hi @aak1
Why don't you use the Repeating Section?
Add the email control into the Repeating Section. Users will be able to add emails for a dynamic number of users
Hi @Garrett
Yes, that makes sense. I just have to figure out how to extract the emails from the field connected to the repeating section now. Thanks!
Hi @aak1
Save the Repeating Section to a SP Multiline Plain Text field (Long-Text).
Fill up one form and submit it. This will save the data into the field.
Use the XML Query to extract the data from the field.
Refer to
https://community.nintex.com/t5/Nintex-for-Office-365-Forum/XML-Query-repeating-section/m-p/219666
If you have any difficulties, paste the XML value and I can guide you to extract the email
Thanks, @Garrett ! I've got the following XML
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version>1.0</Version><Items><Item><_e008d784d6a233e23a7f7ae63fe10299 type="System.String">email1@domain.com</_e008d784d6a233e23a7f7ae63fe10299></Item><Item><_e008d784d6a233e23a7f7ae63fe10299 type="System.String">email2@domain.com</_e008d784d6a233e23a7f7ae63fe10299></Item></Items></RepeaterData>
I've got the query as: /RepeaterData/Items/Item/ , but I can't tell what the last thing behind Item should be.
Use any online XML formatter or beautifier tool to structure the XML
Your XPath query is /RepeaterData/Items/Item/_e008d784d6a233e23a7f7ae63fe10299
That's what I guessed it was, I just wasn't sure. Putting that in and giving an output of a collection variable. I tried logging to history to see what was in the collection, but I just get an error stating "XML content is invalid. Data at the root level is invalid. Line 1, position 1.."
Did you refer to this page?
Did you view the XML settings on the page?
Yes, I reviewed that page and I can see no difference between what is there and what I've done. Obviously something is different, I just don't know what.
Hi @aak1
You create a Form with a Repeating Section, right?
Which SP (multiline plaintext type) column is connected to the Repeating Section?
When you view this SP column, do you see the XML, right?
So, when you perform the Query XML, should you be referring to this SP column?
In the example, the SP column is "Huddle Interventions",
and as such the XML source is "{Current Item:Huddle Interventions}"
Whereas you are pointing to the "Current Item". Why is that?
Cheers
Hi @aak1
Wrong mindset, its not a mistake, its a learning opportunity 😎
Glad you manage to solve the issue
Cheers
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.