Unanswered

Form.updates not working

(0) Share

Report

Posted on by meklulose

I have a gallery which people can use to create new list in SharePoint. The user can use old values in the selected gallery and it will contain attachment. I have added the following code on Submit.

Patch('List',Defaults('List'),{
Title:DataCardValue3.Text,
},
Form2.Updates)

The attachment which comes from the selected gallery doesn't get added to the new SharePoint list. I can delete the attachment from the screen and re-add it again and that will add the attachment to a SharePoint list. So it is probably happening because the canvas app doesn't see pre-populated attachment as update so hence it doesn't get uploaded to the SharePoint. Is there a work around for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@meklulose

If you are using a form, you should be using the SubmitForm function to submit your form - not a Patch statement.

You should be using: SubmitForm(Form2)

I hope this is helpful for you.

Was this reply helpful? Yes No
meklulose 34 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes thanks for taking your time to reply. I have used patch as there are conditions that I need check for certain fields and update other fields according to what the user has entered in certain field. I believe with submitForm I can't do those statement. The form 2 just has the attachment so if I just so SubmitForm(Form2). It will create a new record with just that attachment in it which I do not want.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@meklulose

The form is far superior to anything you can do by hand in any quick fashion.

What you are describing for checking fields and updating other fields according to other field entries is ALL very possible with a form.

I would suggest getting the form to function as you like first and leave all of the submitting to the form as well as all validation and error handling (which is what it does).

If you have a particular problem that surfaces from validating the form or from submitting the form, please elaborate on that and I can provide some assistance to help you get that resolved. But, essentially, your goal is to be at a point where SubmitForm is what you use and it does what you want.

Was this reply helpful? Yes No
meklulose 34 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes The form have been broken down into multiple screen as it is too long to be displayed in 1 screen. The user can click next and populate the forms and then patch creates 1 record using the information filled in. The patch will also set value of an optional field in SharePoint list item (same data source as form)as "Yes" if user has ticked a checkbox which isn't part of the form. If I use SubmitForm(Form1); SubmitForm(Form2);SubmitForm(Form3) then it will tries to create multiple SharePoint list items when it should just be 1 item created. Is there workaround from this so I can still use SubmitForm() or another way I can use to Form2.Updates to add in attachment to a new item list from an existing item list. Many thanks!

Was this reply helpful? Yes No
kky1 550 on at

Like (0)

Report
Copy link

Link copied!

Hello @meklulose - did you find a solution to your question. I have exactly the same scenario with a form broken into multiple screens, but one of my screens has prefilled data based on the logged in user. The form on that screen doesn't pass into my Sharepoint list using the Form.Updates function and SubmitForm isn't an option because the submit occurs on the next screen.

Was this reply helpful? Yes No