Hi @v-monli-msft,
This is complete scenario…
Our customer have 3 sp list: Personal information, Contact Information and Job History. Personal info list is primary list and his ID we need to write in other two list as foreign key (entity relationship 1toMany).
We start to customize form for Personal Info for New, Edit and View items. For the purpose of UX we need to bring other two form (Contact info, Job History) on same screen. User see only Personal info list in SharePoint and when click on New button sp open PA form with all 3 list… this is print screen:
We manipulate with Visible property of all 3 list on same screen. Depends on which Menu Item is select we set Visible property of that form. Very simple.
Everything is perfect when user select to view one previous entered item. Form Personal info show all fields, when click on Job History, we set Visible property for Personal info form on False and set Visible property of Job History form on True and with this function in Items property of form/gallery
Filter(JobPosition, ContactID = SharePointIntegration.Selected.ID)
We show all related dates.
Problem is when user start with New button on list for Personal info and write all required fields in Personal info and click on Job history menu item. In this moment we don’t know ID of Personal list to give it to Job history form. We need to SubmitForm Personal info when user click on Job history menu (or contact menu). When we SubmitForm, PA write all necessary fields in SP and reset form on the first item in list but we need to stay on new item and show empty form of Job History with button Add New Job…
My question is How to submit form and stay on Last added item?
In OnSucess property I use this:
If(_menuItemSelected="Job History", false, ResetForm(SPFormAdresar);RequestHide())
Item of form:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First(Adresar),SharePointIntegration.Selected)
