cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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

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

Tags (4)
0 Kudos
Reply
5 Replies
Workflow Hero

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

‌  ‌  ‌  ‌  ‌ 

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.

Accept as Solution Reply
Workflow Hero

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

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.

0 Kudos
Accept as Solution Reply
Workflow Hero

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

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

0 Kudos
Accept as Solution Reply
Workflow Hero

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

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?

Accept as Solution Reply
Workflow Hero

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

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.

0 Kudos
Accept as Solution Reply