Unanswered

PowerApp Edit Form Now Saving / Overwriting Data after the completion status drop down status is "Complete"

(0) Share

Report

Posted on by jchammons

My PowerApp will not save or overwrite my data to the Sharepoint List (hence the data does not update in the PowerApp) is the "status" from a dropdown menu datacard has previously been selected as "Complete". I can go into the associated Sharepoint List and edit the record. Then the PowerApp shows the update.

However, once a user selects "Complete" in the status dropdown field in the PowerApp; it appears the PowerApp will not allow the edit form to save / overwrite data to the Sharepoint List. I can not find any code disabling the Edit Form or Save Button from working if the status is "Complete". I do not remember setting anything up in the app or code.

Please help!!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

One 416 on at

Like (0)

Report
Copy link

Link copied!

Hi @jchammons,
The first things that come to mind would be:
What mode is your form in? Are you sure that when you select an existing record to edit that the form is being set to Edit Mode rather than New?
What is the OnSelect code for your submit button?
What is the code in the update property for your datacards?

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report
Copy link

Link copied!

To help answer your questions:
What mode is your form in? DefaultMode = FormMode.Edit
Are you sure that when you select an existing record to edit that the form is being set to Edit Mode rather than New? OnSelect = EditForm(EditForm_Bridge);Navigate(EditForm_Bridge)
when clicking the chevron arrow on the browse screen gallery
What is the OnSelect code for your submit button?
OnSelect = SubmitForm(EditForm_Bridge);Navigate(BrowseScreen_Bridge)
What is the code in the update property for your datacards?
Update = DataCardValue132.selected for my "Review Status" which can be selected 'Pending' or 'Complete'
Honestly I am not sure where the 132 is coming from.

It appears that "Person or Group" field will not allow updates. My date fields can be edited and the changes will save. But I try to change the "person or group" and it does not change when I hit the save button to submit the form. Even when I choose "Pending" as my status, the person or group change will not save. My status field is a choice field for "pending" or "complete".

I can actually edit the record in Sharepoint directly in my list. Then the changes are saved. However, if I try to edit in the PowerApp, then it will not save the changes.

Does that make any sense? It is weird. I have been using this PowerApp that I made since last October and never noticed this. I was expanding the use of the app and noticed this anomaly.

Was this reply helpful? Yes No
One 416 on at

Like (0)

Report
Copy link

Link copied!

@jchammons,
that is strange, you don't have anything in your code that would prevent it from submitting anything. is the dropdown in your field set to person? see attached screenshot.

------------------------------------------------------------------------------------------------------------------------------
Please click "Accept as Solution" if this post answered your question so that it is helpful for people having similar questions. If you found this post helpful smack that Thumbs up button! Thanks!

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report
Copy link

Link copied!

Yea. The layout is set to "Person". Here is a screen shot of the settings for that data card.
Also "Items" = Choices([@'Plan Review'].OData__x0031_stLevelReviewer_x0028_Bri)
It appears that the reason this is a problem is that the field is a "Person or Group" field. A similar thing happens with my "Choice" field for the status. The status choice field is blank. After I select "Pending" or "Complete" which are the only 2 choices, then it will not let me delete and leave the field blank. I can change the status choice field thought to either of the 2 choices.

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

Like (0)

Report
Copy link

Link copied!

Hi @jchammons ,

It seems you are using cascading dropdowns? Could you please share the column names from your SharePoint list? From in your screenshots, the person column Items seems not from the list directly. We will have the Items of a Person/Choice column Combo box like Choices(List.ColumnName).

Best regards,

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report
Copy link

Link copied!
Here is an example of one of the columns. Yes I left spaces. Probably shouldn't do that.
Actual Sharepoint Column Name = 1st Level Reviewer (Bridge)
Under "Items" for this drop down selection menu in PowerApps
"Items" = Choices([@'Plan Review'].OData__x0031_stLevelReviewer_x0028_Bri)
Again I can change it on the Sharepoint List and it shows up in PowerApps. However, I cannot change these drop down selections in PowerApps and it will not save my change. The field is a Person/Group choice combo box.

I think there is a way to make this work but just don't know yet.

Was this reply helpful? Yes No