Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Data Table Filter

(1) ShareShare
ReportReport
Posted on by 48

Hi Everyone,

 

Im currently making a job request form, and I want to create an approval checker page but i want the submitter can only check the approval process of their requested form.

 

I am using this formula to only filter the submitter request, but the formula keep getting error alert

Filter('Job Requisition',StartsWith('Submitter'.DisplayName,TxtInput.Text))

safiranrd_1-1719817078139.png

 

 

Do anyone have any idea why my formula is not working? Any kind of assistance is really appreciated, have a great day!

 

  • safiranrd Profile Picture
    safiranrd 48 on at
    Re: Data Table Filter

    Working just like how i want it, thank you @anandm08 !

  • Re: Data Table Filter

    Hi @safiranrd ,

     

    This is a delegation warning, not an error. This warning means that if your data source has more than 2,000 records, it may not return correct results.

    If your data is less than 2000, please try to modify the delegation threshold.

    vxiaochenmsft_0-1719817342827.png

     

    Best Regards,

    Wearsky

  • Verified answer
    anandm08 Profile Picture
    anandm08 1,936 on at
    Re: Data Table Filter

    hi @safiranrd ,

    The issue with your formula is likely due to how you're referencing the 'Submitter' field and the StartsWith function. To filter the 'Job Requisition' list based on the current user's DisplayName, you should ensure that you are using the correct field reference and value comparison.

     

    Filter('Job Requisition', Submitter.DisplayName = User().FullName)

     

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard