Skip to main content

Notifications

Community site session details

Community site session details

Session Id : vK2NN34lqIz3elypmKMg6Y
Power Apps - Building Power Apps
Answered

For All with Filter

Like (0) ShareShare
ReportReport
Posted on 9 Nov 2023 00:12:03 by 178

Hi Team,

 

Was wondering if its possible to use for all with a filtered collection.

 

Some reason I cant get it working.

 

Any help is greatly appreciated.

 

Thanks

 

ClearCollect(Estimates,
 ForAll(Filter(PTP_Meter,READ > 100 && READ < 200),
 {
 INDEX: PTP_Meter[@INDEX],
 READ_DATE: PTP_Meter[@READ_DATE]}))

 

  • MudassarSZ365 Profile Picture
    591 on 09 Nov 2023 at 00:19:02
    Re: For All with Filter

    hi @christian12 ,

    try this 

    ClearCollect(
     Estimates,
     ForAll(
     Filter(PTP_Meter, READ > 100 && READ < 200),
     {
     INDEX: INDEX,
     READ_DATE: READ_DATE
     }
     )
    )

    Kindly mark the solution as accepted if it resolves your issue.

    Best Regards
    Muhammad Mudassar Mazhar

  • Verified answer
    SpongYe Profile Picture
    5,559 Super User 2025 Season 1 on 09 Nov 2023 at 00:16:55
    Re: For All with Filter

    Hi @christian12 

     

    Maybe try chaning the datasource name to ThisRecod:

    ClearCollect(
     Estimates,
     ForAll(
     Filter(PTP_Meter,READ > 100 && READ < 200),
     {
     INDEX: ThisRecord.INDEX,
     READ_DATE: ThisRecord.READ_DATE
     }
     )
    )

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard
Loading started