Setting variable to Item that was submitted via a NewForm, not EditForm.

[ChrisSullivan]

I have an App where the first screen is a Gallery is pulling information from a SharePoint List. 

I have a New button that goes to the Newform for the SP list and an Edit button that set a variable to the Gallery's selected Item Set(selecteditem, Gallery1.selected) and goes to the edit form for this list. 

On the Next screen a form mode  Variable sets the form for that SP list to either NewForm or EditForm based on what they wanted to do from the first screen. 

What I want to happen with the FormMode.New is when they Submit the form, I want the selecteditem to now become the item that was just created, not gallery1.selected. Or, have a way to have Gallery1 to select the current item just added so the variable matched the current item. 

I want to avoid having the User go back to the first gallery and select the item again just to set the variable. 

The reason I want this is I also have galleries that use the selecteditem variable elsewhere and they are not updating the current items because they are set to what ever was last selected from gallery 1, not the New item. 

[RandyHayes]

@ChrisSullivan 

There is no difference between a "NewForm" and an EditForm.

PowerApps has two form types - ViewForm and EditForm.

ViewForm can only be in view mode.

EditForm can be in New or Edit or View modes.

As with any Edit form, you can capture the Record that was submitted in the OnSuccess action of the form using the following formula:

   Set(varLastRecord, Self.LastSubmit)

I hope this is helpful for you.

[ChrisSullivan]

I suppose my question is then how would I set the New and edit form to work with what I have so far. 

The New item button:  Onselect =  Set(varMode,"New");Navigate(INITIAL);

The Edit button : Onselect = Set(selecteditem,Gallery1.Selected);Set(varMode,"Edit");Select( Parent            );Navigate(INITIAL,ScreenTransition.None)

Second screen on visible = If(
varMode = "New",
NewForm(Form2),
EditForm(Form2)
);
UpdateContext({TimerReset: true});
UpdateContext({TimerReset: false});
UpdateContext({ResetText: false});
ClearCollect(
AppsData,
AppsGallery.AllItems.Application_x002f_System_x0020_N
)

[ChrisSullivan]

I forgot to mention the Form in question Item is set to selecteditem. This work perfect right now. Edit form grabs the data from selecteitem. New gives a blank form. 

[RandyHayes]

@ChrisSullivan 

Change your formula to the following on the OnSelect of the New Item button:    

NewForm(Form2); Navigate(INITIAL)

Change the formula on the Edit Button OnSelect to the following:

Set(selecteitem, ThisItem); EditForm(Form2); Navigate(INITIAL)

Get rid of OnVisible formula.

Change the Reset property of your Timer to :  App.ActiveScreen.Name = "INITIAL"

Not sure what ResetText is used for, but that can be replaced if I had more details on it.

Not sure what you are using AppsData for, but that can be moved elsewhere and the collection gotten rid of as you don't need a collection for what you have there unless you plan to Add or Remove rows from the collection table in the app...which wouldn't really apply when related to the AppsGallery.

Bottomline - Your AppsGallery already is a table/collection, just reference it as needed and cut the performance overhead of the collection.

[ChrisSullivan]

Thanks for the feedback Randy!

This still does not solve my issue though. 

My understanding is you cant LastSubmit from a FormMode.New

The reason I need this to happen is this

The first Gallery populates all the items in SP list (Initial),

In this gallery I have a button to edit an item;      

Set(selecteditem,Gallery1.Selected);Set(varMode,"Edit");Select( Parent );Navigate(INITIAL,ScreenTransition.None)

I also have a New button outside of the gallery to make new items in the Initial list;

Set(varMode,"New");Navigate(INITIAL);

On the second screen is the form for Initial and a Gallery (AppsGallery)

AppsGallery pulls its data from a separate SP List (Appsdata)  

Filter('App Data',SourceID=selecteditem.ID)

There is also an Add New App  button;

 Set(VarNewApp,true);Navigate(AppDataScreen,ScreenTransition.None)

Onselect of the Gallery Item brings them to the edit form for that specific item in the Appsdata list

Set(VarNewApp,false);Set(VarEditApp,true);Set(Appselecteditem,AppsGallery.Selected);Navigate(AppDataScreen,ScreenTransition.None)

When the User presses Add New App, they navigate to the next screen with Appsdata's Form on it set to New form. They fill it out, and submit, but when they do a a field called SourceID is updated to be selecteditems.ID. This is the common data element between the to lists, and how Apps gallery shows just apps associated with the Initial project. This work seamlessly. Now for the big but,

But, When you start a new project on screen1 with the New button it brings you to Screen2 to fill out the New form for Initial. Now selecteditem is not selected, so there is no data for AppsGallery to use. And if they try to add a new app, there is no selecteditem.ID so it never populates in SourceID so the item gets orphaned on the list with no owner. Another big problem is if the user has just worked on another project and then want to make a new one. When they hit new Screen2 show a new form but Appsgallery is still populated with the items from the last project.

My thoughts were to hide the AppsGallery on screen2 if formmode is New and have the Add New App button onselect:
        

SubmitForm(Form2);
        Set(VarNewApp,true);
        Navigate(AppDataScreen,ScreenTransition.None)

And then, have the OnSuccess of the Initial form to;

 Set(selecteditem, Form2.Lastsubmit)

This would grab the correct ID for the app to keep working, but unfortunately it is not grabbing the data, and research is showing that you can not get data from LastSubmit from a Formode.New. 

The only other option I can think of id forcing the user to go back to the first screen select the project they just created and then edit it, and have the AppsGallery visible only when the form is in Formmode.Edit. This seems like a silly way to do this, I was hoping to find a better way around this. 

[ChrisSullivan]

Also for the Collection. This is doing what you were suggesting. It is pulling just the apps names from the Items with the same source ID as selecteditems.ID and Concat them into a data card for the Initial List Item, just so there is a place when I make reports to show all apps associated with the project. 

[RandyHayes]

@ChrisSullivan 

I am not sure where you got the incorrect information that LastSubmit is not available for a form in New mode, but it is wrong.  You most certainly can get that info/record.

You're overcomplicating the solution a bit.  It is far simpler than I believe you are going.

To be sure I am on the right track with you...

As I understand it:

  A) You have a Gallery with a list of records from your SharePoint list. 

  B) Users can select a record to Edit.  This will take then to Screen INITIAL

  C) Your INITIAL screen has a Form in it for the Record Selected from step B.  The screen ALSO contains a Gallery  (Apps Gallery) pulling records from another datasource based on the SourceID being the same as the current record under edit.

  D) The user can select a record in the Apps Gallery which will take them to another Screen - AppsDataScreen with an Edit form to edit the record selected in step C

  E) The screen mentioned in Step C also contains an "Add New App" button to allow the user to create a new record on the AppsDataScreen.  When doing so, the EditForm for the Apps data needs to know the SourceID from the Primary record in order to relate the record to the master record.

This is all classic Parent/Child record creation that is not a problem to do and will not have this complexity you are experiencing.

But first, please confirm that I have the above assumptions correct and then I will provide the details of what you need to do.

[ChrisSullivan]

Yup you got it!
That is how it works, and it does work perfectly in till you try to make an entirely New project. 

[RandyHayes · Accepted solution]

@ChrisSullivan 

Very good.  I thought it was the case, but didn't want to offer a long response based on a bad assumption.

So, with that in mind, here is the details for each step:

A) You have a Gallery with a list of records from your SharePoint list. 

Assuming some Items property on the Gallery of: yourList or Filter(yourList, someCriteria)

B) Users can select a record to Edit.  This will take then to Screen INITIAL

Your OnSelect action of the Gallery should be:

   Set(selecteditem, ThisItem); EditForm(Form2); Navigate(INITIAL)

  C) Your INITIAL screen has a Form in it for the Record Selected from step B.  The screen ALSO contains a Gallery  (Apps Gallery) pulling records from another datasource based on the SourceID being the same as the current record under edit.

Your DataSource property for Form2 should be: yourList

The Item property of Form2 should be: selecteditem

The submit button for this form should be: If(Form2.Unsaved && Form2.Valid, SubmitForm(Form2))

The OnSuccess action of Form2 should be: Set(selecteditem, Self.LastSubmit); EditForm(Form2)

D) The user can select a record in the Apps Gallery which will take them to another Screen - AppsDataScreen with an Edit form to edit the record selected in step C

Your Apps Gallery has a Items property of : Filter('App Data', SourceID=selecteditem.ID)

The Visible property of the Gallery should be: !(Form2.Mode = FormMode.New)

The Visible property of the Add App button should be : AppsGallery.Visible

The OnSelect action of AppsGallery should be: EditForm(AppDataForm); Navigate(AppDataScreen) (note: not sure the name of your AppData Edit form, so replace as needed)

The Item property of AppDataForm should be : AppsGallery.Selected

The SourceID field in your AppDataForm should have the following Update property on the DataCard: selecteditem.ID

The submit for the AppDataForm should be : SubmitForm(AppDataForm)

The OnSuccess for the AppDataForm should be: Back()

E) The screen mentioned in Step C also contains an "Add New App" button to allow the user to create a new record on the AppsDataScreen.  When doing so, the EditForm for the Apps data needs to know the SourceID from the Primary record in order to relate the record to the master record.

Now the simplicity...the OnSelect action of the Add New App button is : NewForm(AppsDataForm); Navigate(AppDataScreen)

That should be all you need. Put it in place and get rid of all the other variables and things, you don't need them.