Copy existing items and submit as a new item in power apps gallery and forms

(1) Share

Report

Posted on by YC-24070300-0

Hello all Power Apps experts,

Here I have a new problem.

My homepage in Power Apps is a gallery data table with items information and there's a bottom called copy this item.

With clicking this bottom, I hope the user could skip to a new screen with the item he chose. In this new screen, he can change any information he wants to change and by clicking the submit bottom, he will skip to successful screen and a new item will be created in the gallery data table.

So for the "copy this item" bottom in p2, I just use the function navigate in on select session.
For the "submit" bottom in p3, I use the function in on select:

Patch(Sharepoint data source, Defaults(Sharepoint data source),FormCopy.Updates);

SubmitForm(FormCopy);

Navigate(ScreenSuccess));

However, it could not jump to the success screen and could not submit at all.

Anything wrong with my function or is there any advice?

Thanks!

Regards,

Yiqian

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

YC-24070300-0 on at

Like (0)

Report

Re: Copy existing items and submit as a new item in power apps gallery and forms

Hi Bof,

Thanks for your advice. I have amended my function and it works quite well now. Amazing!
For my question, I also found the problem is that I also used the if function in "submit" bottom's on select part to remind the user fill in all fields but the last bracket is in the wrong place.
Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Copy existing items and submit as a new item in power apps gallery and forms

Hi @Yiqian ,

The formula looks fine , is there any error message?

In addition, if you just want to copy an item , there is no need to submit the form , you could try:

Patch(Sharepoint data source, Defaults(Sharepoint data source),FormCopy.Updates); ResetForm(FormCopy); Navigate(ScreenSuccess);

Best Regards,
Bof