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