Hi @LoopinG2023 ,
That is why I asked you the initial question - the Person fields must be multiple value if you are getting that error and if this is the case, you have a Delegation issue. I am also assuming that Statut is a Yes/No field.
You can maybe partially address the issue with
With(
{
_Toogle:
If(
toogleEnCours.Value,
"En cours",
"Terminé"
)
},
With(
{
_Data:
Filter(
'Appels d''offres',
Statut.Value = _Toogle
)
},
Filter(
_Data,
varUserEmail in Juristes.Email = Or
varUserEmail in 'Responsables RSE'.Email Or
varUserEmail in 'Pilotes Opérationnels'.Email
)
)
)
but you will need the top toggle filter to return record numbers under your Data Row Limit to filter on all available records.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
