How can avoid the Error using removeif function

[EdevaldoJeronim]

Hi,

I need to remove some records in TblMenuUserAplic located in Sharepoint List according to the code below highlighed in red color but i have 02 situations:

1 - the function "IfError()" don't show me the error in the screen (notify) and how i can do it?

2 - How can avoid the error "The specified record was not found. Server response. Failed TblMenuUserAplic: Item not found clientrequestid: xxx " when i execute the function remove() below. Is there a way to avoid it?

See code below:

IfError(

          ClearCollect(TblTempGrupoAplic;Filter(AddColumns(TblGrupoAplic;"IdUser";LookUp(TblMenuUserGrupo;IdGrupo =             TblGrupoAplic[@IdGrupo];IdUser));IdGrupo = 1));
          Notify( "Internal error: " & ErrorInfo.Control & " - Property: " & ErrorInfo.Property & " - Message: " & ErrorInfo.Message);

/* Remover os itens da aplicação */
         RemoveIf(TblMenuUserAplic;(IdUser in TblTempGrupoAplic[@IdUser]));

         Notify( "Internal error: " & ErrorInfo.Control & " - Property: " & ErrorInfo.Property & " - Message: " & ErrorInfo.Message)

);

[RaashiSen]

Hello @EdevaldoJeronim ,

For IfError(<situation>,Notify("")), Notify() expects a comma(,) before it works, in your code you are using semicolon(;), which is to disconnect the action, not chain them together.

Please replace them and see if that works. Something like-

IfError(

     ClearCollect(TblTempGrupoAplic;Filter(AddColumns(TblGrupoAplic;"IdUser";LookUp(TblMenuUserGrupo;IdGrupo =             TblGrupoAplic[@IdGrupo];IdUser));IdGrupo = 1)),  Notify( "Internal error: " & ErrorInfo.Control & " - Property: " & ErrorInfo.Property & " - Message: " & ErrorInfo.Message)

);

For your second ask, we can try using If( IsError( RemoveIf(TblMenuUserAplic;(IdUser in TblTempGrupoAplic[@IdUser])) ), Notify( "" ) ). 

Please check and tell if that helps 🙂

[EdevaldoJeronim]

Hi @RaashiSen ,

For Brazilian language we need to change colon(,) to semicolon (;) and semicolon(;) to double semicolon (;;)