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)

Verified answer

Gabriel G. 831 Super User 2025 Season 2 on at

Like (1)

Report

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 Super User 2025 Season 2 on at

Like (0)

Report

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