Answered

Saving a form to a Sharepoint list - Working from time to time

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am using PowerApp to create forms used to create/modify items in a Sharepoint Online list. However, I have an issue: from time to time (1 time on 5 on average), the behavior is different than the one expected and I loose all the data I entered in the form.

There is nothing special in what I am doing. I just call the "RequestHide()" function in the "OnSuccess" event. My issue is that the behavior changes without any reason. Here are the two cases:

NORMAL CASE

I click edit on one item of the list ==> The form appears populated with the list content

I click "Save" (standard button) ==> sometimes moving "balls" appear saying that this is ongoing, but most of the time, this is quite instantaneous: the data is saved and the form is closed.

ABNORMAL CASE

I do exactly the same than in normal case, but when I clic Save, the form doesn't close and reloads instead the content form the item of the list, replacing the changes I just made. The form doesn't close.

This looks random: sometimes it saves, sometimes it looses the modifications (by reloading the initial data) and keep the form opened. I couldn't find any relationship with the network status, the browser used or whatever.

How can I solve that ? Is there any way to go a bit deeper in the debug to understand why some times the form doesn't save the data and reload the old ones instead ?

Now, to be complete, I had to add some code in the advanced tab of the form to have the data loaded in the form when it appears... this may be the source of the problem, but if I don't put this, the form never loads any data (stucked with the message "Getting your data...". Here is the code (in Advanced/Data/Item field):

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@PMO_reporting]),SharePointIntegration.Selected)

I think that this code is called when the form is launched and that it populates the data (which was the goal). But I have the impression that it is sometimes called for some reason when I try to save the form, and the result is that all the form data is replaced.

Does somebody has an idea how to solve this ?

Best regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you customize a form within your SP List using PowerApps?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please make sure the Item property of the SharePointForm1 to following:

If( IsBlank(SharePointIntegration.Selected.Executor.Claims) || IsEmpty(SharePointIntegration.Selected), First([@'Your SP List']), SharePointIntegration.Selected )

Set the OnNew property of the SharePointIntegration to following:

Refresh('Your SP List'); NewForm(SharePointForm1)

set the OnEdit property of the SharePointIntegration to following:

Refresh('Your SP List'); EditForm(SharePointForm1)

set the OnView property of the SharePointIntegration to following:

Refresh('Your SP List'); ViewForm(SharePointForm1)

Please take a try with above solution, then re-published your custom form app to your SP List, check if the issue is solved.

If the issue still exists, please remove the custom form app from your SP List, then re-add a new one for it, take a try with above solution I mentioned, check if the issue is fixed.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

First of all, many thanks for the answer and sorry for the delay for my feed-back. In facts, as the behaviour is not always the same, I am not sure that this fixed the issue. But in one day, several people will use the form, so I will have a more complete feed-back. At the moment, the latest test I did were OK (no issue seen).

I updated the OnNew, OnEdit and OnView properties as you proposed. Concerning the Item property, I couldn't use your proposition, because the first parameters generates an error. When I put "SharePointIntegration.Selected.Executor.Claims", it is not recognized. I don't know exactly why. So for the moment, I kept my "SharePointIntegration.Selected" parameter I put in the "IsBlank()" function.

I will post an update to this discussion as soon as my team will have used the form (they use it once a week) and that I will have gotten a full feed-back.

Best regards.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

It's my fault. The Executor is actually a Person type column in my SP List.

On your side, you need to keep the original formula within the Item property of the SharePointForm1:

If( IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected), First([@'Your SP List']), SharePointIntegration.Selected )

You could take a try with above solution I provided, check if the issue is fixed.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I had to wait a bit as the team is using the form mainly once a week. But your solution clearly improved the situation. I cannot confirm 100% that it solved all cases, but for sure this is a lot more reliable than before. Many thanks for that.

Cheers.

Was this reply helpful? Yes No