You’re offline. This is a read only version of the page.
372
Hi,
I used this formula to get value from my SP List.
Share
ReportFilter('WM FOR WELDER REGISTER', 'Grup Name Assembly' in SubAssy.Selected.Value, NoDrawing.Text in 'No Drawing')
But I got delegation for 'in' function. I tried to using another formula like this:
Filter('WM FOR WELDER REGISTER',StartsWith('Grup Name Assembly',SubAssy.Selected.Value),StartsWith('No Drawing',NoDrawing.Text))
But it show nothing.
Can anyone help me to make this formula delegable? Thankyou!
@firda59 ,
It will not if you require 'Middle' to be anywhere in the field - if you require the in filter in both areas, you simply cannot make it Delegable. This code will not solve your Delegation issue (only mask it on some occasions) if StartsWith will work for the Text Box
All responses (
Answers (
With(
{
_Data:
Filter(
'WM FOR WELDER REGISTER',
StartsWith(
'No Drawing',
NoDrawing.Text
)
)
},
Filter(
_Data,
SubAssy.Selected.Value in 'Grup Name Assembly'
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
I used in because value in SP list and dropdown are different, I mean:
In SP List it just 'Middle' but in dropdown 'Body Middle Side',
like that,
so I used in function.
I try your formula, and it show nothing:(
Hi @firda59 ,
Firstly the in filter simply is not Delegable, however I suspect your drop-down needs to equal the selected value
Filter(
'WM FOR WELDER REGISTER',
'Grup Name Assembly' = SubAssy.Selected.Value &&
StartsWith(
'No Drawing',
NoDrawing.Text
)
)and then you can use StartsWIth on the other field. Also set the Default of your NoDrawing Text Box to "" (empty string)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
