Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

For All with Filter

(0) ShareShare
ReportReport
Posted on 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
    MudassarSZ365 591 on at
    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
    SpongYe 5,378 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard