Patch and Collect

[Harley525]

Hello,

I made a formule i think it is oke but it doesen't at up.

Can some one help me out. 

[BCLS776]

A few things I'll point out.

First, your Patch() appears to have an error: a control name (highlighted pink) is being used where a column name for your data source should be. You should be referencing the column name you want Dmschrijving.Text stored.

Second, you have a Collect statement for the same data source immediately after (highlighted in green) that appears to be adding empty strings to the data source -- do you really need to do that? If so, what's the purpose?

Bryan

[StalinPonnusamy]

Hi @Harley525 

Please clarify what exactly you are trying to do.

The below command gets the response from the Patch command. This includes all data you patched, ID, and Link to Item

ClearCollect(ColName, Patch())

And Collection is Table. So to get ID or Link we need to use First like

First(ColName).ID OR First(ColName).'Link to item'

[Harley525]

What i am trying to make is that i want to store the line into share point and after that i want a empty line for the next line. i have seen this in a video from shane young info path.

i want to do the same.

[Harley525]

What i am trying to make is that i want to store the line into share point and after that i want a empty line for the next line. i have seen this in a video from shane young info path.

i want to do the same.

[StalinPonnusamy]

Hi @Harley525

I assume you have Edit Form and using the Patch command to save data. To refresh the form,

Set the OnSuccess property of the EditForm to

Refresh(DataSource);
NewForm(EditFormName);

My Sample

[Harley525]

I am using a newform for this 

[StalinPonnusamy]

OK. Select the form and set the OnSuccess property of the form to

NewForm(EditFormName);

This clears the data and should be ready for another item to enter.

[Harley525]

Sorry i forgot it is gallery in a form.

[WarrenBelz]

Hi @Harley525 ;

Your syntax (I have assume European here) needs to be something like this - I am also assuming Omschrijving is the name of your Text Box (if not use that control's name)

Patch(
   'Aanvraag Artikelen';
   {ID:ThisItem.ID}; 
   {Artikelnr:Omschrijving.Text}
);;
Collect(
   'Aanvraag Artikelen';
   {LineItem: ""};
   {LineItem: ""};
   {LineItem: ""}
)

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.