Skip to main content
Nintex Community Menu Bar

How To Query NF Form Data From Separate List (O365)

  • February 24, 2018
  • 5 replies
  • 53 views

rhia
Nintex Partner
Forum|alt.badge.img+15

Hey folks!

I don't use O365 too much, and I'm trying to grab the XML from NF Form Data from another list item.

What's happening is that it comes back as "Null" every time. 

Even if I just do Query List > Filter on ID with an ID I know exists > Get column "NF Form Data" ... nothin'.

Thoughts?

Thanks!

rhia

5 replies

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Author
  • Nintex Partner
  • February 26, 2018

‌  ‌  ‌  ‌  ‌ 

I am @-ing the people who are at the conference with me because if they help me figure this out I will buy them a drink or something.


jesse_mchargue
Forum|alt.badge.img+12

Did we talk about this one?

I think we solved a different question that we were discussing, but let me know if you are still in need of an extra set of eyes to look it over.


Forum|alt.badge.img+5
  • Nintex Partner
  • March 14, 2018

What about a Web Request to the SharePoint REST API to get the value of the hidden field?


Forum|alt.badge.img+17
  • Nintex Partner
  • April 4, 2018

I've actually never tried that. Could this be done on premise this way? In the workflow on the current item it is known as Form Data and not NF Form Data, don't know it as a column though. What if you had a workflow on the source list that copies the FormData xml to a multiline text field, the query it directly? Do you have to keep that field up to date per change in the form?


Forum|alt.badge.img+5
  • Nintex Partner
  • April 5, 2018

Yes, you could create a multiline plain text field called FormDataXml and copy {ItemProperty:NFFormData} into it at the beginning of the workflow.  It would cause an item update, but would at least make it available in a queryable property.