submit only checked components of a form

(0) Share

Report

Posted on by LisKr

304

Hi,

my app contains a formula connected to a sharepoint list. The formula contains comboboxes and checkboxes next to them. What I want to achieve is, when the user submits the form, only the comboboxes that are checked get submitted to the list.

How can I achieve that? Can I do it through a submit function or do I need to use a patch function?

Here you have a screenshot of the app, maybe that helps to imagine

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @LisKr ,

I recommend you use Patch function because SubmitForm will update all fields.

OnSelect of Button.

Patch(Table,Defaults(Table),{Computer:If(ComputerCheckBox.Value,ComputerTextInput.Text,""),Monitor1:If(MonitorCheckBox.Value,MonitorTextInput.Text,"")})

Best regards,

Rimmon

Was this reply helpful? Yes No
LisKr 304 on at

Like (1)

Report
Copy link

Link copied!

@v-mengmli-msft
Thank you for your reply. I will try that and update this thread if it worked.

Was this reply helpful? Yes No
LisKr 304 on at

Like (0)

Report
Copy link

Link copied!

@v-mengmli-msft
Your solution worked. Thanks for helping!

Was this reply helpful? Yes No