ResetForm issue

(0) Share

Report

Posted on by Rama96x

149

Hello everyone!

I'm trying to both Submit a Form and at the same time Patch the value from a dropdown into a Sharepoint list (the dropdown is inside of the Form). However, whenever I submits the form, the dropdown value defaults back to the first value inside of the dropdown. Because of this, it patches the first value of the dropdown and not the value that the user has picked.

Notes:

I have 2 different Sharepoint List where the first one is basically the SubmitForm and the second one is data that is in the Dropdown value which I want to patch to the first sharepoint list.

I have added some images for a better understanding of my issue!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey! On OnSelect property of the dorpdow set a var:

Set(varDropdown; Dropdown1.Selected.Value)

Then, on DefaultSelectedItens write:

varDropdow

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
Rama96x 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, thanks for the reply. Where can I find the DefaultSelectedItems propoerty? 🙂

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

My mistake. Dropdown only has Default.

But write on default. Is the same

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
Rama96x 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Just did that, nothing seems to work. As soon as I click on the button that submits the form, it just defaults the dropdown back to the fist value and patches that

Was this reply helpful? Yes No
Rama96x 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, It kind of works now, but now it just defaults back to the prior value. So whenever I submit, it just takes the value that was one before @Nogueira1306

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rama96x ,

If you want the Last submitted value you can use below formula while patching the record.
YourFormName.LastSubmit.ColumnValueYouRequire

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.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Because you ahve the property on OnSelect. To make sure, you need to select it again. Or Set it in another part, for example, after you patch

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
Rama96x 149 on at

Like
a
(1)

Report
Copy link

Link copied!

So I'm patching on the OnSuccess property on the form itself, and setting the variable after the patch here doesn't work either 😕

Was this reply helpful? Yes No
Rama96x 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @PriyankaGeethik , it's basically the dropdown value that sets to default everytime I submit my form which therefore isn't patching the correct value, that I'm trying to figure out 🙂

Was this reply helpful? Yes No
Rama96x 149 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked on the OnChange property! Will accept this as the solution - thank you for your help 🙂

Was this reply helpful? Yes No