When form is New Reset it

(1) Share

Report

Posted on by Sri

559

Hi All,

I have a gallery which based on the Project name navigates to the screen which has a form. I am using the same form for New and Edit form. On select of the gallery I have a code:

Set(
varproject,
LookUp(
'Project Review List',
'Project Name' = TextInput8.Text,
'Project Name'
)
);
If(
Is Blank(varproject),
Newform(Form2),
Edit Form(Form2)
);
Navigate('ProjectReview_New Screen');

and on the Form Item Property I have given a code:

LookUp(
'Project Review List',
'Project Name' = Gallery6.Selected. Project Name
)

and the Default mode of the Form is Edit since I'm using the same form for Edit and New. The error which I am facing is when I select a project called "Ridley " it if exists in SharePoint list it navigates to the Edit form or else New form. Edit form is working fine. When I edit few details for the Ridley project and submit it gets saved to the SharePoint . And the next time again I navigate for the next project called CBRE it reflects the saved value from the Ridley Project. Only if I go back to the gallery page and navigate again to the form it Resets the form or else it shows the previous saved values. I tried to write the Reset form on the Visible property of the screen where the Form is it gives me "No item to display" message when I navigate from gallery.

Ay help/ suggestion on this would be greatly appreciated.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

gcmfaizan 1,022 on at

Like (1)

Report
Copy link

Link copied!
Hi @Uthhra ,

try this formula on the DisplayMode property of your form instead set the Display mode of from on another screen:
If(IsBlank(varproject), FormMode.New, FormMode.Edit)
and can add logic to reset the form when you navigate to it from the gallery. Add the following formula to the OnVisible property of the form screen:
ResetForm(Form2)

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

Hi @gcmfaizan ,
It is working but when I submit the form it has to stay in the same page for further details to be entered. So I'm getting No items to display for some few seconds and then It resets the form since Reset Form code is written onVisible.

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (0)

Report
Copy link

Link copied!
If you want to navigate back to the screen where you use the gallery, so for this use
Back()
function OnSuccess property of the form. an OnVisible property of this screen uses the Refresh function
Refresh('Project Review List')
to refresh the data source.

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Uthhra ,

Maybe you can try this, set the On Success of the Form2:

Set(var1,Form2.LastSubmit.'Project Name')

Set the Item of the Form2:

LookUp(' 'Project Review List', 'Project Name'=var1)

Best regards,
Rimmon Li

Was this reply helpful? Yes No