Help with new item SharePoint Integration Form

[Bunly11]

Hi -

I have a SharePoint Integration form that I am trying to save a new record and stay on the same form.

I then want to be able to navigate to the next form to enter the components.

If(IsBlank(LookUp(ComponentsMF, DrugID = SharePointIntegration.Selected.ID)),EditForm(Form1),NewForm(Form1));
Navigate(ComponentsScreen, ScreenTransition.Fade, {varDrugID: SharePointIntegration.Selected.ID,varDrugTitle: SharePointIntegration.Selected.Title})

When I enter a new item it does save the form (i.e Drug 1234)

but when I navigate to to the next page the item selected defaults to the first record for another drug (Drug A)

If I go back and edit the item from the main form CompondingRecords - it then works

Any suggestions on how to enter a new item then have it pull the selected ID on the next form?

Thank you.

[WarrenBelz]

Hi @Bunly11 ,

Change these two values

{varDrugID: Form1.LastSubmit.ID,varDrugTitle: Form1.LastSubmit.Title})

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.

[Bunly11]

Hi @WarrenBelz 

I tried changing the last two values

If(IsBlank(LookUp(ComponentsMF, DrugID = SharePointIntegration.Selected.ID)),EditForm(Form1),NewForm(Form1));
Navigate(ComponentsScreen, ScreenTransition.Fade, {varDrugID: Form1.LastSubmit.ID,varDrugTitle: Form1.LastSubmit.Title})

but then on Form1 the screen was blank:

I use a lookup for the form on form1 

LookUp(ComponentsMF, DrugID = varDrugID)

and  I use filter for the gallery on form1

Filter(ComponentsMF, DrugID = varDrugID)

Would you have any suggestion on what I should change these to?

[WarrenBelz]

@Bunly11 ,

Where do you save the new record? I cannot see SubmitForm() anywhere. When you save, the code I supplied will work as it will refer to the last saved ID and display that record in your form.

[Bunly11]

Hi @WarrenBelz 

I have the submit form on the Onselect below

But when I use below the Drug ID and Title do not default

 {varDrugID: Form1.LastSubmit.ID,varDrugTitle: Form1.LastSubmit.Title})

Should I change the Submitform?

[WarrenBelz]

Hi @Bunly11 ,

Something is wrong here - put this on a label

Form1.LastSubmit.ID

and see what is in it after you save - it should be the ID of the new record (or the existing one if you edited).

[Bunly11]

hi @WarrenBelz - nothing appeared on the label after I submitted. I even tried switching the forms around.

Is this because when I enter a component for a drug in the ComponentsMF list it doesnt populate the drug name and ID in the sharepoint list until after I save?

Should I just start over 😂

[WarrenBelz]

Hi @Bunly11 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

[WarrenBelz · Accepted solution]

@Bunly11 ,

Sorry missed last post - you are correct - you cannot get the reference to a new item until you save it (the record does not exist until then)

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.

[Bunly11]

Hi @WarrenBelz 

Thank you so much! It makes sense now.

I tried over with a new SharePoint integration form and still was not able to get it to work. 

I will just accept that when I hit save on the SharePoint Integration form - I will just have to go back and edit.

Thank you for help with this!