CREATE NEW RECORD FROM PREVIOUS SHAREPOINT ENTRY

[chudson002]

@WarrenBelz 

Warren, you have been so helpful with my previous submissions, was hoping you could assist with this.

Weekly, information is submitted to a SharePoint list via a form. Much of the time, the info does not change, but still have to submit with new date.  To eliminate the user from copying and pasting into a new form every week the same info as the week before, want the user to:

• Select the previous week, form will open in edit mode with previous week's data (this works without any issues)
• Change date 
• When form is submitted, a new record will be created with the new date holding the previous week's info.

Any guidance you can provide will be greatly appreciated.

V/R

chudson002 

[chudson002]

Warren,

I struggle with understanding variables and can see this is where the disconnect is.

In the Variables list, there is only VarItem.

Am I suppose to name varItem1 something?  Does "item1" suppose to be something else?

V/R

chudson002

[WarrenBelz]

@chudson002 ,

Did you use the "long" code I supplied doing each Patch individually?

Set(
   varItem,
   Patch(
      OALCWeekly,
      Form1.Updates
   )
);
Set(
   varItem2,
   Patch(
      OALCWeekly,
      Form2.Updates
   )
);
Set(
   varItem3,
   Patch(
      OALCWeekly,
      Form3.Updates
   )
);
Set(
   varItem4,
   Patch(
      OALCWeekly,
      Form4.Updates
   )
);
Set(
   varItem5,
   Patch(
      OALCWeekly,
      Form5.Updates
   )
);
Set(
   varItem6,
   Patch(
      OALCWeekly,
      Form6.Updates
   )
);
NewForm(Form1);
NewForm(Form2);
NewForm(Form3);
NewForm(Form4);
NewForm(Form5);
NewForm(Form6)

If so, you should have a value for varItem2 (and also 3-6). You are setting six separate Variables to be used separately on the six forms. I have changed the first one to varItem to save changing Form1. 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[chudson002]

What am I setting varItem2 to?

V/R

chudson002

[chudson002]

Do I have to create each variable first and what value do I give it?

 

[WarrenBelz]

@chudson002 ,

The result of the Patch of Form2 (and the same for the rest).

Can you please take a small step back and read this document. You need to understand the logic of what you are doing otherwise I will never solve this for you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[chudson002]

Warren,

Saw the article and will take a deeper dive into it.  Struggled with collections in the beginning, but got past that obstacle.  I will get it.

V/R

chudson002

[WarrenBelz]

@chudson002 ,

If this helps, each of these Variables each being set to a record (a line of fields if you like) being what was Patched. The new forms can then use VariableName.FieldName as the Default of the relevant field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @chudson002 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.