Answered

Adding navigate after successful patch?

(0) Share

Report

Posted on by michelledroll1

Hello,

I want to navigate to another screen if patch has been performed successfully but can't figure out the syntax. Please help!

If(IsBlank(LookUp(Clerical_PRD,Title=Trim(DataCardValue40_2.Text) && City = Trim(DataCardValue3_2.Text)&& Proj_Date = (DataCardValue28_1.SelectedDate))),

Patch(Clerical_PRD, Defaults(Clerical_PRD),

{

Title:Trim(DataCardValue40_2.Text),

Status: DataCardValue12.Selected,

City:Trim(DataCardValue3_2.Text),

Shop:DataCardValue2.Selected,

Project: Trim(DataCardValue29_2.Text),

Work_Type:Trim(DataCardValue5.Text),

Proj_Date:DataCardValue28_1.SelectedDate

}),

Notify("This Address/City/Work Type/Date already exists",NotificationType.Error,3000);

);

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
IfError( If(IsBlank(LookUp(Clerical_PRD,Title=Trim(DataCardValue40_2.Text) && City = Trim(DataCardValue3_2.Text)&& Proj_Date = (DataCardValue28_1.SelectedDate))), Patch(Clerical_PRD, Defaults(Clerical_PRD), { Title:Trim(DataCardValue40_2.Text), Status: DataCardValue12.Selected, City:Trim(DataCardValue3_2.Text), Shop:DataCardValue2.Selected, Project: Trim(DataCardValue29_2.Text), Work_Type:Trim(DataCardValue5.Text), Proj_Date:DataCardValue28_1.SelectedDate }), Notify("This Address/City/Work Type/Date already exists",NotificationType.Error,3000); ), false, Navigate(pageName, navigateType))
michelledroll1 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much!
michelledroll1 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I spoke too soon.
I am trying to navigate if I don't have a condition and not a not a system error.
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
If this condition,

IsBlank(LookUp(Clerical_PRD,Title=Trim(DataCardValue40_2.Text) && City = Trim(DataCardValue3_2.Text)&& Proj_Date = (DataCardValue28_1.SelectedDate)))

is NOT true in your first example it goes to here INSTEAD of making a patch

Notify("This Address/City/Work Type/Date already exists",NotificationType.Error,3000);

you would just add your navigate there.
michelledroll1 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I'm still not understanding.
Is there a way to tell the app to go to another screen if the patch was successful?