Unanswered

Modify a value in the list after form is submitted

(0) Share

Report

Posted on by Spedoo41225

Hi All,

I have created a form on power apps, is the classical form where you have on the left the gallery, and once the user click on of the items of the gallery, he has on the right, the edit form view, so the user can edit. I also added at the bottom a "submit" button with the formula of submit form.

Here comes my question for you. The form is connected to a sharepoint list. One of the list of this list is the "current status". I want, after the user submit the form, to have the sgarepoint list updated with the current status as "Approved".

So when the user see the form, make the edits, click on submit, and i would like to have the column "current status" on the sharepoint updated, so i can recognize that the form was successfully submitted.

Maybe, do you have any formula or suggestion for me?

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

JasonLane 261 on at

Like (0)

Report
Copy link

Link copied!

Hi @Spedoo41225
I have something similar but using SQL (Principle is the same though) - I create the form as a collection called "CurrentForm" and then use the below to change the form status - Mine is for Adjust:

/* Set new status */
UpdateIf(
CurrentForm,
FormID = CurrentFormID,
{
FormStatus: "Adjusted",
UpdatedDateTime: Now()
}
);
Trace("Update old form");
/* Write back new status */
Patch(
'QA.Form',
CurrentForm
);

I then go on to create a new form as im adjusting but the above will get you started without knowing all the details of the Form you have.

I hope this helps.

Thanks

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Spedoo41225

Type of column 'current status'?

Add the current status card to the form. Set its Update property to submitted. Hide the card.

Was this reply helpful? Yes No
Spedoo41225 56 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp , it's a choice type in the share point list. Before the user submit the from, using the app, the "current status" value is "Pending". After the user review the item via the app, and click on submit, the Current Status column should change to "Approved". Meaning that the user has reviewed and approved.

But this should change only after the user click on submit. Because, when the user click on submit, the user is validating the items shown in the SharePoint, so that's why the column called "Current Status" should be changed as "approved".

Any help you might provide is really apprecitaed

Thanks

Was this reply helpful? Yes No
Spedoo41225 56 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz, @BCBuizer , would you have any idea ? 😊 Thanks

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Spedoo41225

It seems obvious to me to change the value when the form is submitted rather than afterward. The value won't change if the form doesn't successfully submit.

Was this reply helpful? Yes No
Spedoo41225 56 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp yes but is not the user to change this value, actually i'm going to hide this data card for the user. So it should be the form to automatically change the "current status" value after the user click on submit button.

D0 you know which formula should i use ?

Thanks

Was this reply helpful? Yes No
JasonLane 261 on at

Like (0)

Report
Copy link

Link copied!

@Spedoo41225 see my first reply - This changes the "current status" based on a click of button

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (2)

Report
Copy link

Link copied!

@Drrickryp already provided you the appropriate answer. You just put the card on the form, change it's /default/ to Approved on the datacard. When the user submits the form, it will automatically change the column in splist to the default value on the form, which was approved, and your value will update. Now if for some reason you are not using submitform() for your form submission and are just trying to patch the data from the form instead, then you should change to submitting the form the correct way.

Was this reply helpful? Yes No