After item submit, same record is not able to load

[MihirY]

I am using list with customized powerapp form. After item got submitted to list, I am not closing the screen. Instead i am showing the same screen to the user by enabling some other options. But unfortunately after when i submit the item to list, submission was successfull, but instead of to load newly added item to the form, it is loading first item from the list. This is because, there is a formula applied on Item property of new form which is as below, which means after submission SharePointIntegration.Selected is coming as empty. Any solution?

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('Expense Submissions'),SharePointIntegration.Selected)

[v-xida-msft]

Hi @MihirY,

Could you please share a bit more about your scenario?

Do you want the new created record to be loaded within the same screen when you submitted the data?

I have made a test on my side, please take a try with the following workaround:

• Set the OnSuccess property of the SharePointForm1 to following formula:

ResetForm(SharePointForm1)

• Set the Items property of the SharePointForm1 to following formula:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
Last('20180405_case7_Users'),
SharePointIntegration.Selected
)

Note: The '20180405_case7_Users' represents the SP list on my side.

On your side, you should type the following formula within Items property of SharePointForm1:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
Last('Expense Submissions'),
SharePointIntegration.Selected
)

The GIF image as below:

Best regards,

Kris

[MihirY]

This is the solution that I have implemented. But this is a work around, not a solution in my view. Because based on this saved item, i am doing some other operations. I need to use SharePointIntegration.SelectedItemId but, this is coming as blank. So i need to write a custom formula to get the item id based on Last('DataSource).

[v-xida-msft · Accepted solution]

Hi @MihirY,

If you want to get the Item ID of the new created record within your SP list, please take a try with the following formula:

Last('Expense Submissions').ID

When you edit an item within your SP list, the SharePointIntegration.SelectedItemID formula would return the Item ID of the edited item. But when you create an item within your SP list, the SharePointIntegration.SelectedItemID formulawould return empty (or blank).

More details about SharePoint forms integration, please check the following article:

SharePoint forms integration

Best regards,

Kris