Answered

Patch Function : Unexpected characters. The formula contains 'Eof' where 'ParenClose' is expected.

(0) Share

Report

Posted on by floxfloat

100

I'm getting this strange error after adding lookup function next Patch . wondering what could I be missing here....Appreciate your support to this Thank you

If(
    dd1.SelectedText.Value <> "test" And dd1.SelectedText.Value <> "-",
    Patch(
        'FFMC-Off Boarding Users',
        LookUp
            ('FFMC-Off Boarding Users',ThisRecord.ID =  Gal_ActiveUsers.Selected.ID,
                {
                    ID: Gal_ActiveUsers.Selected.ID,
                    'Checklist Locked To': Blank(),
                    Status_: "Completed"
                }
            )
    );
          Navigate(MainS);
)

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Gabriel G. 831 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yeah, you need to separate the record selection from values to change:

If(

  dd1.SelectedText.Value <> "test" And dd1.SelectedText.Value <> "-",

  Patch(

  'FFMC-Off Boarding Users';

  LookUp

('FFMC-Off Boarding Users',ThisRecord.ID =  Gal_ActiveUsers.Selected.ID);

{

ID: Gal_ActiveUsers.Selected.ID;

'Checklist Locked To': Blank();

Status_: "Completed"

}

  );

Navigate(MainS)

)

I hope it helps you with your issue!

Was this reply helpful? Yes No
Suggested answer

jrletner 720 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try this and see if it helps.

This changes "ThisRecord.ID" to ID and removes ID from the patch, because you should already have the current ID through the lookup.

If(
dd1.Selected.Value <> "test" And dd1.Selected.Value <> "-",
Patch(
'FFMC-Off Boarding Users',
LookUp('FFMC-Off Boarding Users', ID = Gal_ActiveUsers.Selected.ID),
{
'Checklist Locked To': Blank(),
Status: "Completed"
}
);
Navigate(MainS)
)

Was this reply helpful? Yes No