Skip to main content
Nintex Community Menu Bar
Solved

Forms for SharePoint Online

  • April 15, 2024
  • 9 replies
  • 423 views

Forum|alt.badge.img+4

I would like to design a form in Nintex Automation Cloud and then enter data into that form that would populate my SharePoint list. 

 

I have my connection and Data source set up, and the design of my SharePoint list is created. I know how to create a start event to create a design form and know how to create a new list item in a workflow, but I don’t know how to connect the fields on the form to the SharePoint list.

 

Can you share with me a link, tutorial or solution for this? Hopefully a tutorial, so I better understand it. It looks like I need to create a task form, but I don’t understand how to do that.

Best answer by SimonMuntz

Hi @csergent7,

If you want to display start event variables on your task form, Drag controls from the start event variables section of the controls toolbox.

 

 

View original
Translate
Did this topic help you find an answer to your question?

9 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • April 16, 2024

Hi @csergent7,

When you create an item with the SharePoint Online - Create an item action, you input the site and the list details.  When you click the add fields button, the columns from the list will be available for selection.
Select the columns you want to populate, and then add the appropriate form variable to your selected fields.

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 17 replies
  • April 16, 2024

 @SimonMuntz - I am having trouble connecting the data to the fields, unless what I did is correct. Here are the steps I followed:

  1. I created a Workflow and selected the start event, SharePoint Online and the event; New or update list item
  2. Populated the connection and the site URL and then retrieved lists
  3. Selected list; I clicked on the button that displays show variable in the start event, and my list was in the Start variable
  4. Selected Assign a task to multiple users
  5. Selected task form and entered in design mode
  6. Selected form variables, selected a variable, and named the form variable
  7. I then place the variable in default value as I didn’t see an controls for data sources

The goal in this case is to enter the number of days a location is open, which will be entered into a SharePoint Online list.

 

Here is what my one field form has:

Nintex Automation Cloud, for Entering Data to SharePoint Online

 

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • Answer
  • April 16, 2024

Hi @csergent7,

If you want to display start event variables on your task form, Drag controls from the start event variables section of the controls toolbox.

 

 

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 17 replies
  • April 17, 2024

Thank you. One last thing, the data is read only; how do I change it to editable?

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • April 17, 2024

Hi @csergent7 

 

 

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 17 replies
  • April 18, 2024

@SimonMuntz that’s what I am having trouble with. How do I make the field editable?

Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • April 18, 2024

Hi @csergent7,

 

As the message advises, you cant make the field editable.
Nintex forms are for entering New information and not for editing existing information.

 

To achieve this solution, you would need two fields. One that shows the current value and another to collect the new value. When the new value is collected you use it to update the item.

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 17 replies
  • April 19, 2024

@SimonMuntz I think I am getting a better grasp on understanding. Just two questions to ensure I understand correctly.

  1. To update a list; if I have a field named; first_Name, with short text as the data type, I would need to add a short text control and name it first_Name and then upon clicking submit, the first name would be updated. Is that correct?
  2. What if the form is for new data only? How would I create the form to enter the information?
Translate

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2436 replies
  • April 21, 2024
csergent7 wrote:

@SimonMuntz I think I am getting a better grasp on understanding. Just two questions to ensure I understand correctly.

  1. To update a list; if I have a field named; first_Name, with short text as the data type, I would need to add a short text control and name it first_Name and then upon clicking submit, the first name would be updated. Is that correct?

No this is not correct.  When you hit submit you then use a SharePoint Online update item action to update the column with the new information.
 

csergent7 wrote:
  1. What if the form is for new data only? How would I create the form to enter the information?

It's the same principle.  You just update the column with the new data.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings