Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

using ForAll function

Hi guys, I want to create loop through my Employee list. But still I didn't get good knowledge to do it with ForAll function. I need some help to learn working with this function.  Can I use If co...
ImkeF's avatar
ImkeF
Community Champion
2 years ago

Hi Syndicate_Admin ,
your question landed in the wrong forum (Power Query for Power BI instead of Power Apps).
So if this answer isn't enough, please re-post it in the Power Apps forum.

You can use conditions like so:

 

ForAll( Products,
    If( 'Quantity Requested' > 'Quantity Available',
        {
            Product: Product,
            'Quantity To Order': 'Quantity Requested' - 'Quantity Available'
        }
    )
)

 

See documentation here:
ForAll function in Power Apps - Power Platform | Microsoft Learn