Unanswered

FormSubmit with Sharepoint integration does now show created in editForm

Like (0) Share

Report

Posted on 17 Feb 2023 19:03:04 by ialbasheir-kbr

I have SharePoint List form edited with PowerApps. but I am having an issue with the form that it is not showing the newly created item in edit form after it got created (I disabled hideform). "formsubmit" does switch the form for New to Edit form but I noticed that the form goes empty. is it because the fact the sharepointIntegration.Selected is blank inside the form onSuccess? btw Form.LastSubmit is available. I am thinking of a workaround to have Form.LastSubmit set in Form.item. Thank you.

Categories:

General Questions

All responses (2)

Answers (0)

ialbasheir-kbr 73 on 21 Feb 2023 at 15:20:23

Like (0)

Report

Re: FormSubmit with Sharepoint integration does now show created in editForm

Thank you, Warren.
I did some tests. and you are correct. there is a need to interact with sp for the integration to load up. Kinda annoying since I am still in the form and it should be treated similar to canvas app behavior. and let me tell you it is unpredictable at best I have seen behaviors that on success the form sometime loads up random that I could not wrap my head around due to SharePointIntegration.SelectHidden weird behavior. It is problematic at best. but thank you again for giving some clarity. it feels we are steered away from directly interacting with SP as we are discussing going to canvas app.
WarrenBelz 148,838 Most Valuable Professional on 17 Feb 2023 at 20:44:37

Like (1)

Report

Re: FormSubmit with Sharepoint integration does now show created in editForm

Hi @ialbasheir-kbr ,

That is correct as generally all Forms Items are based on SharePoint on SharePointIntegrated.Selected (or an element of this), which does not refresh until you return to SharePoint and select another record. If is easy to fix in a Canvas app by basing the Item on a Record Variable (or a Lookup on this variable ID which I do) and then updating this at Form OnSuccess to the last submitted record.

However in an integrated app, some things such as App OnStart and Screen OnVisible do not run unless you refresh SharePoint in the browser (the app for performance reasons is "still open"), so selecting another record would not always set this Variable to the record the user has selected - conversely SharePointIntegration.Selected always updates and displays the record chosen.

So you can try a Variable OnSuccess, but be aware of the shortcomings mentioned.

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.

MVP (Business Applications) Visit my blog Practical Power Apps