You’re offline. This is a read only version of the page.
Announcements
10
hi everyone,
I am trying to build an app that connects to a Sharepoint list but getting Delegaion warning.
(The right side of the "In" operator should be a column name from the correct data source. the data source might not be able to process the formula and might not return correct results or behave correctly if the data set is incomplete.)
Applying the below formula on my Galley and attaching the Delegation warning screen shot and formula
Filter(
'CPS-Gate-Pass',
Substitute(
DropdownGatePassType.SelectedText.Value,
"All Gate Pass",
""
) in 'Gate Pass Type'.Value,
Substitute(
DropdownStatus.SelectedText.Value,
"All Status",
""
) in Status.Value,
Or(
TextInputSearch.Text in Title,
TextInputSearch.Text in ID,
TextInputSearch.Text in 'Created By'.DisplayName
)
)
Is there a workaround for this.
Thanks in advance
Rajeev
Unfortunately, there does not appear to be a way to make this delegable to SharePoint the way it is currently structured. The "in" operator, as well as the Substitute() function, makes this non-delegable.
If you need to use the "in" operator, consider bringing the data into an internal collection or using a datasource such as Dataverse that supports delegation on that operator.
Hope that helps,
Bryan
Share
Report
All responses (
Answers (
