Answered

Data Table Filter

(1) Share

Report

Posted on by safiranrd

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))

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Best Regards,

Wearsky

Was this reply helpful? Yes No
safiranrd 50 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No