Create validation in the button

(0) Share

Report

Posted on by Pizzolati

198

Hello, I need some help validating the button to prevent it from creating the same links. I have the following screen:

in it I can link / unlink machines / equipment. formula in the link button:

ForAll(
 ForAll(
 Filter(
 'GalleryTodasMaquinas/Equips'.AllItems;
 Checkbox2.Value=true
 );
 {
 'ID- Máquina':ThisRecord
 }
 );
 Patch(
 'Vínculos Funcionário/Máquina';
 Defaults('Vínculos Funcionário/Máquina');
 {
 'ID- Funcionario': GalleryTodosFuncionariosAtivos.Selected;
 'ID- Máquina': ThisRecord.'ID- Máquina'
 }
 )
)

However, I can create the same link infinitely many times. I would like to know if it is possible to create a validation between the two galleries so that I cannot create the same link more than once.

I tried using the following formula but without success the button always becomes inactive for some reason:

If(
 !IsBlank('GalleryTodasMaquinas/Equips'.Selected); // Verifica se há itens selecionados na primeira galeria
 If(
 !IsEmpty(
 Filter(
 GalleryTodosVinculadosMaq.AllItems; // Todas as máquinas vinculadas na segunda galeria
 'ID- Máquina' in ForAll(
 'GalleryTodasMaquinas/Equips'.AllItems; // Todas as máquinas selecionadas na primeira galeria
 'ID- Máquina' // Retorna uma lista de IDs das máquinas selecionadas na primeira galeria
 )
 )
 ); // Verifica se há alguma máquina na segunda galeria que está na lista de máquinas selecionadas na primeira galeria
 DisplayMode.Disabled; // Se houver uma correspondência; desabilita o botão
 DisplayMode.Edit // Se não houver correspondência; permite a edição do botão
 );
 DisplayMode.Disabled // Se não houver itens selecionados na primeira galeria; desabilita o botão
)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Ramanachiappan 179 Moderator on at

Like (0)

Report

Re: Create validation in the button

Hi @Pizzolati ,

Try this one.
Link button:
ForAll(
Filter(
'GalleryTodasMaquinas/Equips'.AllItems,
Checkbox2.Value=true
) As Record,
Patch(
'Vínculos Funcionário/Máquina';
Defaults('Vínculos Funcionário/Máquina');
{
'ID- Funcionario': GalleryTodosFuncionariosAtivos.Selected;
'ID- Máquina': Record.'ID- Máquina'
}
)
)

Button disable:
If(
!IsBlank('GalleryTodasMaquinas/Equips'.Selected);
If(
CountRows(
Filter(
GalleryTodosVinculadosMaq.AllItems;
'ID- Máquina' in ForAll(
'GalleryTodasMaquinas/Equips'.AllItems;
'ID- Máquina'
)
)
)=0,
DisplayMode.Disabled,
DisplayMode.Edit
),
DisplayMode.Disabled
)

Best regards,
Ramanachiappan M

If my response was helpful, please select "Accept as solution" to close the item. Your thumbs up would be highly appreciated if you found it useful. Thank you!

Was this reply helpful? Yes No
Pizzolati 198 on at

Like (0)

Report

Re: Create validation in the button

Hi Ramanachiappan, thanks for your reply. The formula to avoid creating identical links doesn't seem to have worked, I still manage to select a machine that already has a link and link it! Which is not the case.

Was this reply helpful? Yes No
Ramanachiappan 179 Moderator on at

Like (0)

Report

Re: Create validation in the button

Hi @Pizzolati ,

Try this one
Button disable:
If(
!IsBlank('GalleryTodasMaquinas/Equips'.Selected);
If(
CountRows(
Filter(
GalleryTodosVinculadosMaq.AllItems;
'ID- Máquina' in ForAll(
'GalleryTodasMaquinas/Equips'.AllItems;
'ID- Máquina'
)
)
)>0,
DisplayMode.Disabled,
DisplayMode.Edit
),
DisplayMode.Disabled
)

Best regards,
Ramanachiappan M

If my response was helpful, please select "Accept as solution" to close the item. Your thumbs up would be highly appreciated if you found it useful. Thank you!

Was this reply helpful? Yes No
Pizzolati 198 on at

Like (0)

Report
Re: Create validation in the button

Hi Ramanachiappan, thanks for your reply. The formula to avoid creating equal links doesn't seem to have worked, the same error that I commented on in my post happened, now the button is always inactive.

And also in the following formula that you gave me for Linking:
ForAll( Filter( 'GalleryTodasMaquinas/Equips'.AllItems, Checkbox2.Value=true ) As Record, Patch( 'Vínculos Funcionário/Máquina'; Defaults('Vínculos Funcionário/Máquina'); { 'ID- Funcionario': GalleryTodosFuncionariosAtivos.Selected; 'ID- Máquina': Record.'ID- Máquina' } ) )
the following error occurs:
the type of this argument 'cre14_IDMachine' does not match the expected type 'Record'. Type 'Error' found

Was this reply helpful? Yes No
Ramanachiappan 179 Moderator on at

Like (0)

Report

Re: Create validation in the button

Hi @Pizzolati ,

If the previous code is functioning properly, it's advisable to stick with it. However, I need confirmation on whether the disable function code I was provided is also working correctly or not.

Best regards,
Ramanachiappan M

If my response was helpful, please select "Accept as solution" to close the item. Your thumbs up would be highly appreciated if you found it useful. Thank you!

Was this reply helpful? Yes No
Pizzolati 198 on at

Like (0)

Report

Re: Create validation in the button

Hello, so it's not working as I said the button now always stays inactive, even selecting a machine that is not linked!

Was this reply helpful? Yes No
Pizzolati 198 on at

Like (0)

Report
Re: Create validation in the button

Hi, I'm still having the same problem as before, even if I mark links other than the one that already exists the button still doesn't work
Formula:
If( !IsBlank('GalleryTodasMaquinas/Equips'.Selected); If( CountRows( Filter( GalleryTodosVinculadosMaq.AllItems; 'ID- Máquina' in ForAll( 'GalleryTodasMaquinas/Equips'.AllItems; 'ID- Máquina' ) ) ) > 0; DisplayMode.Disabled; DisplayMode.Edit ); DisplayMode.Disabled )

Was this reply helpful? Yes No
Pizzolati 198 on at

Like (0)

Report

Re: Create validation in the button

So I tried to do some validations by filtering my gallery by only those that have the CheckBox set to true, but to no success!

Was this reply helpful? Yes No
Verified answer

Pizzolati 198 on at

Like (0)

Report
Re: Create validation in the button

I managed to do it using the following formula in my gallery filter:
Filter( 'Máquinas e Equipamentos'; Ativo = true && IsBlank( LookUp( GalleryTodosVinculadosMaq.AllItems; 'ID- Máquina'.Descrição= Descrição ) ) )

Was this reply helpful? Yes No