Answered

How to add an If Statement that edits a form field upon submission

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

My current app is to help track a production rate and allows user to open a work order, close a work order, or enter a daily rate. Is there a way to have the submit button add in a note or edit a field that will help signify this? My first thought was to add another field with 3 choices (Open Work Order, Close Work Order, Enter Daily Rate) and upon submit have it select one of those choice, but I was unable to get a function to work.

Thank you,

Matt

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share the formula on your submit button?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Currently for my
Start/Close Work order page I have
SubmitForm(EditFormSEWO)
For my Edit Daily Rate page I have
Patch('Production Rates', Defaults('Production Rates'), EditFormEDR.Updates) because I haven't been able to get something to work.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

So it sounds like you want to patch or submit this information along with the other data?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, thats correct. I want to submit a form and upon submission if possible have one of the fields auto-populated.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

How will the submit know which value to choose?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That's what I was trying to figure out. I'm not sure how to incorporate an IF statement that would select an option on an form field. Because the pages are separate I was thinking that the 'Enter Daily Rate' would be easy and upon select it would pick an option, but the Open/Close work order would just be selecting one (Either open or close) and the other could be the default option on that screen.

I guess the formula I would be looking for would be something that selects a value on a form field, then I would incorporate that function into an IF statement.

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

If you have a choice field already where Open/Close Work Order is selected, you would just use that value as the default value in your DataCard where you want it recorded.

So your DataCardValueXX default value or text value would be something like: XxxControl.Selected.Value and then it would automatically populate that column in your data source when the form is submitted.

For the Enter Daily Rate, you could set a variable to 'Enter Daily Rate' on the button or icon you are using to navigate to that screen and then just patch the variable value to the Data source column.

Was this reply helpful? Yes No