Answered

Button OnSelect command termination due to empty field in patch

(0) Share

Report

Posted on by rob4681

Hello Everybody,

I am patching data to various SharePoint lists and want to stop all patching of data if a certain condition is met.

In the case below I want to stop the patch if the fields OperatorDropDown.Selected.Operator || BoxDropDown.Selected.Box || Value(SlotNoText.Text) are blank or not selected. I am attempting to stop the patch with the If(IsBlank(.... on the second row of code. Ideally I need a solution which just stops executing the remaining code at this point, displays an error message and stays on the same screen which is RCATrackOut.

Set(RCACount,Sum(ForAll(Filter(RCAData, BatchID = DataCardValue16_2.Text && WaferID = DataCardValue28_2.Text),0),Value));
If(IsBlank(OperatorDropDown.Selected.Operator || BoxDropDown.Selected.Box || Value(SlotNoText.Text)),Notify("Some of the fields are empty",NotificationType.Error, Navigate(RCATrackOut)));
Patch(RCAData, LookUp(RCAData, BatchID = DataCardValue16_2.Text && WaferID = DataCardValue28_2.Text),
 { 
 TrackOutTime: Now(),
 TrackOutComments: DataCardValue29.Text,
 TrackOutOperator: OperatorDropDown.Selected.Operator,
 Box: BoxDropDown.Selected.Box,
 ProductID: DataCardValue5_1.Selected.Value,
 SlotNo: Value(SlotNoText.Text),
 ProcessCount: RCACount+1 
 }
 );
Patch(BatchTrack, LookUp(BatchTrack, 'Batch ID'=DataCardValue16_2.Text && 'Wafer ID'=DataCardValue28_2.Text),
 {
 State: {Value: "TrackIn"},
 OpCode: 20,
 Box: BoxDropDown.Selected.Box,
 'Slot No': Value(SlotNoText.Text) 
 }
 );
ResetForm(Form1_1);
Reset(OperatorDropDown);
Reset(BoxDropDown);
Reset(SlotNoText);
Navigate(BrowseScreen1)

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
If you move the actions that you want to happen if there are no error to the third argument of the If function, then they will be executed only if the condition is false (i.e., no errors):

Set(RCACount,Sum(ForAll(Filter(RCAData, BatchID = DataCardValue16_2.Text && WaferID = DataCardValue28_2.Text),0),Value)); If( IsBlank(OperatorDropDown.Selected.Operator || BoxDropDown.Selected.Box || Value(SlotNoText.Text)), // This will happen if there are errors Notify("Some of the fields are empty", NotificationType.Error), // All the commands below will happen if there are no errors Patch( RCAData, LookUp(RCAData, BatchID = DataCardValue16_2.Text && WaferID = DataCardValue28_2.Text), { TrackOutTime: Now(), TrackOutComments: DataCardValue29.Text, TrackOutOperator: OperatorDropDown.Selected.Operator, Box: BoxDropDown.Selected.Box, ProductID: DataCardValue5_1.Selected.Value, SlotNo: Value(SlotNoText.Text), ProcessCount: RCACount+1 } ); Patch( BatchTrack, LookUp(BatchTrack, 'Batch ID'=DataCardValue16_2.Text && 'Wafer ID'=DataCardValue28_2.Text), { State: {Value: "TrackIn"}, OpCode: 20, Box: BoxDropDown.Selected.Box, 'Slot No': Value(SlotNoText.Text) } ); ResetForm(Form1_1); Reset(OperatorDropDown); Reset(BoxDropDown); Reset(SlotNoText); Navigate(BrowseScreen1) );

Hope this helps!

Was this reply helpful? Yes No
rob4681 on at

Like (0)

Report
Copy link

Link copied!

I simplified my code to test, and it works. Thank you.... now to solve the other issues.

Was this reply helpful? Yes No