Power Platform Community Forum Thread Details

Hello everyone, I need some help with the formula. Basically in this part when using

Formula:

ForAll(
 Filter(
 'VinculoServicoFuncionario';
 'ID Servico Prestado'.'ID Servico Prestado' = GalleryTodosPedidos.Selected.'ID Servico Prestado'
 );

 ForAll(
 Filter(
 'Vínculos Funcionário/Máquina';
 'ID- Funcionario'.ID = Text('ID Funcionario'.ID) 
 );
 ForAll(
 Filter(
 'Lista Docs Maquina/Equipamento';
 'Codigo Maquina/Equipamento'.ID = Text('ID- Máquina'.ID)
 );
 Patch(
 ServicosGerados;
 Defaults(ServicosGerados);
 {
 'ID Servico Prestado': GalleryTodosPedidos.Selected.'ID Servico Prestado';
 'ID Documento': Text(ID);
 'Codigo ID Lista': Text('Codigo IDLista');
 'Codigo Departamento': 'Codigo Departamento';
 'Nome Departamento': NomeDepartamento;
 Empresa: GalleryTodosPedidos.Selected.Descricao;
 'Codigo Funcionario': 'ID- Funcionario'.ID
 }
 )
 )
 )
)

the following error occurs on this part :

Filter(
'Vínculos Funcionário/Máquina';
'ID- Funcionario'.ID = 'ID Funcionario'.ID
)

The right side of the “Equal” operator must be a constatn value. However, when I put a Text in any of the IDs

Filter(
'Vínculos Funcionário/Máquina';
'ID- Funcionario'.ID = Text('ID Funcionario'.ID)
)

The error also occurs:

Filter(
 'Lista Docs Maquina/Equipamento';
 'Codigo Maquina/Equipamento'.ID = Text('ID- Máquina'.ID) 
 )

If I use Text in any of them, the delegation occurs, but it works correctly;

However, if I remove Text, the following error occurs: Error trying to retrieve data from the network Could not find a property named 'cre14_IDMaquina' on type 'Microsoft.Dynamics.CRM.cre14_listadocsmaquinaequipamento'

this error no longer occurs but I get the delegation warning that cannot occur in this type of data. I want to avoid delegation or avoid the above error.

In context, I have a table in Dataverse called

'VinculoServicoFuncionario'
. which has the Field

'ID Funcionario'
which is a lookup column in table 'Funcionários where I get ID, and I have the table

'Vínculos Funcionário/Máquina'
which has the column

'ID- Funcionario'.ID
which is also a lookup column in table ''

Second error :

in the table

'Lista Docs Maquina/Equipamento'

has the column

'Codigo Maquina/Equipamento'

in it is a search field for the table "Máquina/Equipamento" searching by id and

ID- Máquina