Answered

SP List Not Updating When Power App Form is Submitted

(0) Share

Report

Posted on by golfnutt82

1,362

Good morning,
I have a power app form that is pulling in data from my "Roles" list into my "Access Request" form.
There are only three fields being populated manually.
1. LU_Role Name
2. Requestor
3. Justification

All other fields are populated based on the key field LU_Role Name

I am using this expression in the OnChange property of the LU_Role Name control to update the fields on the right side of the form.

The issue is that only the Requestor and Justification field is being added to the SP List "Access Requests"
I need all fields on this form to be included.
The logic for the "Submit" button is as follows -

What am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (36)

Answers (2)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@golfnutt82

First, your OnSelect action on your submit button should ONLY be: SubmitForm(NewAccessRequestForm)

SubmitForm is an asynchronous action, so issuing a ResetForm immediately after the Submit will cause the for the reset before the submit has even occurred.

Your ResetForm function should be in the OnSuccess action of the form. Avoid anything after a SubmitForm and put what you want to occur after a successful submit into the OnSubmit.

That is most likely your issue, but if it still does not submit the field you are looking for, then post back with the Update properties of the DataCards for the fields that are not working.

I hope this is helpful for you.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,
Thanks for the help, I learn something new every day!
I will make that change now.
When I submit the form the reset doesnt clear the controls as expected.
Here is what I see when the form resets.
What I was hoping to see is what shows up when a new form is loaded and looks as follows.
This only happens once I reload the page.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,
Still having the same issue.
All the values in the controls (other than - Requestor and Justification) are not being passed to the SharePoint list.
The LU_Role Name is the key field that populates all the data on the left and when the list is populated with all of this data is required for the Power Automate workflow to run.
I created just new form with just the controls and no customization as shown in the existing form and the LU value is passed. So there is something else I did that is causing the issue.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@golfnutt82

Yes, as mentioned - "...then post back with the Update properties of the DataCards for the fields that are not working."

So, let me know what the Update property of the datacard is for one of the columns/fields that is not writing back to the datasource.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe the culpret is the LU_Role Name datacard not passing to the list

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@golfnutt82

Your list of property formulas does not include any of the Update properties on the data cards.

Let's start with just one of the fields that is not being submitted - "Associated Site"

Look at that datacard for that field and let me know what the Update formula is.

I am focused on the Update properties because when a form submits, it submits all the values that are in the Update properties. If nothing is submitted, then that is what submit saw to write out. So, we need to see where it is getting its values from.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

Associated Site like the others are just Text Input boxes and I cant see an Update property for those text boxes on the right.

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!

I dont see the property "Update". Would I see this on a "New" form and not an "Edit" form?
These are custom cards.
Ive looked under properties and under Advanced.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@golfnutt82

The text input control would not have an Update property. Update Properties are only on DataCards.

There is no such thing as a New form and an Edit form. There is only an EditForm control. The only other type of form that there is would be a DisplayForm...and they have no capabilities (and it's not what you have).

If you do not see the update property, then PowerApps has determined that your underlying field is read only and cannot be written.

Tell me more about the Associated Site column in your data list. If you remove that field from your form and then add it back in, what are the control type choices that it provides?

Was this reply helpful? Yes No