Announcements
Hello,
I made a formule i think it is oke but it doesen't at up.
Can some one help me out.
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
Hi @Anonymous
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'
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.
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
I am using a newform for this
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.
Sorry i forgot it is gallery in a form.
Hi @Anonymous ;
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 345 Most Valuable Professional
11manish 207 Super User 2026 Season 2
Mohsin Ali 177
