Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Apps Pro Dev & ISV / Delegation Warning nee...
Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Delegation Warning need to search ID and only user data should visible

(0) ShareShare
ReportReport
Posted on by Jawaharprem 196
 
 
Iam getting Delegation warning, my request is to search a request_id only that request id should be listed and based on user only their request should be listed, and in "Status_Change" if its "Completed or discard" it should not show in the list, iam getting warning as given below
 
Incompatible types for comparison. These types can't be compared: Record, Text.
The function 'Filter' has some invalid arguments.
Name isn't valid. 'Wdata' isn't recognized.
Name isn't valid. 'Status_Change' isn't recognized.
Incompatible types for comparison. These types can't be compared: Error, Text.
Delegation warning. The "StartsWith" part of this formula might not work correctly on large data sets.
Delegation warning. The highlighted part of this formula might not work correctly with column "Request_ID" on
Delegation warning. The "Filter" part of this formula might not work correctly on large data sets.
 
this is code is used - Pervious i used and still now its working fine...
 
With({WData: Filter(CMD_NA_Tracker,StartsWith(Request_ID,requestid2.Text) 
&& 'Assigen to'=User().FullName)},ClearCollect(colGridProssData,Filter(Wdata, Status_Change <> "Completed", Status_Change<>"Discard")))
 
need to solve this issues, pls help on same...
 
 
Thanks
Jawahar R
 
 
 
Categories:
Power Platform Build Tools
error.jpg
  • Jawaharprem Profile Picture
    Jawaharprem 196 on at
    Delegation Warning need to search ID and only user data should visible
    Hi Team,
     
    below mentioned code works, thanks for your time and support..
     
    ClearCollect(
        colGridProssData,
        Filter(
            FirstN(CMD_NA_Tracker, 2000),
            'Assigen to'.Value = User().FullName &&
            (
                StartsWith(Request_ID, requestid2.Text) || IsBlank(requestid2.Text)
            ) &&
            Status_Change.Value <> "Completed" &&
            Status_Change.Value <> "Discard"
        )
    )
  • Jawaharprem Profile Picture
    Jawaharprem 196 on at
    Delegation Warning need to search ID and only user data should visible
    Hi, Thanks all for time, the blowe mentioned codes works but while searching the request_id its not filtering,
     
    ClearCollect(
        colGridProssData,
        Filter(
            FirstN(CMD_NA_Tracker, 2000),
            'Assigen to'.Value = User().FullName &&
            (
                StartsWith(Request_ID, requestid2.Text) || IsBlank(requestid2.Text)
            ) &&
            Status_Change.Value <> "Completed" &&
            Status_Change.Value <> "Discard"
        )
    )
     
  • WarrenBelz Profile Picture
    WarrenBelz 144,858 on at
    Delegation Warning need to search ID and only user data should visible
    Throwing in a couple of suggestions here - assuming you are using SharePoint and you want up to the newest 2,000 items assigned to the user - I assume 'Assigen to' is a Text field. 
    With(
   {
      WData: 
      Sort(
         Filter(
            CMD_NA_Tracker,
            'Assigen to' = User().FullName
         ),
         Created,
         SortOrder.Descending
      )
   },
   ClearCollect(
      colGridProssData,
      Filter(
         Wdata, 
         Status_Change <> "Completed", 
         Status_Change <> "Discard",
         StartsWith(
            Request_ID,
            requestid2.Text
         )
      )
   )
)
    Also I am suspecting Request_ID is a number ? 
    With(
   {
      WData: 
      Sort(
         Filter(
            CMD_NA_Tracker,
            'Assigen to' = User().FullName
         ),
         Created,
         SortOrder.Descending
      )
   },
   ClearCollect(
      colGridProssData,
      Filter(
         AddColumns(
            Wdata,
            ReqID,
            Text(Request_ID)
         ),
         Status_Change <> "Completed", 
         Status_Change <> "Discard",
         StartsWith(
            ReqID,
            requestid2.Text
         )
      )
   )
)
     
  • Shravyashree_10 Profile Picture
    Shravyashree_10 45 on at
    Delegation Warning need to search ID and only user data should visible
     
    You can Ignore the Delegation warning if ---Filter( CMD_NA_Tracker,'Assigen to'.Value=User().FullName)--If This Table doesnt exceed 2000 rows. 
     
    Please mark the ans as verified if it works, Like on the replies are also appreciated!
  • Jawaharprem Profile Picture
    Jawaharprem 196 on at
    Delegation Warning need to search ID and only user data should visible
    Hi thanks for your time, i made some modification on your code most warning cleared expect 
     
    ClearCollect(colGridProssData,Filter(Search( Filter( CMD_NA_Tracker,'Assigen to'.Value=User().FullName ),requestid2.Text,Request_ID), Status_Change.Value <> "Completed"&& Status_Change.
     
    still red mark in Request_id as " Delegation warning. The "Search" part of this formula might not work correctly on large data sets." in setting i already changed to 2000 but getting warning
     
  • Shravyashree_10 Profile Picture
    Shravyashree_10 45 on at
    Delegation Warning need to search ID and only user data should visible
     
    Try-
    ClearCollect(colGridProssData,Filter(Search( Filter( CMD_NA_Tracker,'Assigen to'=User().FullName ),requestid2.Text,Request_ID), Status_Change <> "Completed"&& Status_Change<>"Discard"))
     
     
    Please "LIKE" the replies If this Helps 
    PLEASE GIVE THIS ANSWER A THUMBS UP, IF THIS HELPS AND ACCEPT THIS ANSWER AS A SOLUTION FOR FUTURE REFERENCE!
  • Jawaharprem Profile Picture
    Jawaharprem 196 on at
    Delegation Warning need to search ID and only user data should visible
    getting multiple warnings,
     
    Expected boolean. We expect a boolean (true/false) at this point in the formula.
    Unexpected characters. The formula contains 'KeyNot' where 'ParenClose' is expected.
    Unexpected characters. Characters are used in the formula in an unexpected way.
    Delegation warning. The "StartsWith" part of this formula might not work correctly on large data sets.
    Delegation warning. The highlighted part of this formula might not work correctly with column "Request_ID" on
    Delegation warning. The "Filter" part of this formula might not work correctly on large data sets.
    Expected boolean. We expect a boolean (true/false) at this point in the formula.
    Unexpected characters. The formula contains 'KeyNot' where 'ParenClose' is expected.
    Unexpected characters. Characters are used in the formula in an unexpected way.
    Delegation warning. The "StartsWith" part of this formula might not work correctly on large data sets.
     
  • Suggested answer
    CU02120750-0 Profile Picture
    CU02120750-0 2 on at
    Delegation Warning need to search ID and only user data should visible
    Try this:-
    With(
        {
            WData: Filter(
                CMD_NA_Tracker,
                StartsWith(Request_ID, requestid2.Text) &&
                "Assigen to" = User().FullName
            )
        },
        ClearCollect(
            colGridProssData,
            Filter(
                WData,
                Status_Change Not in ["Completed", "Discard"]
            )
        )
    )
  • Jawaharprem Profile Picture
    Jawaharprem 196 on at
    Delegation Warning need to search ID and only user data should visible
    Hi Thanks for your time, iam getting warning "Name isn't valid. 'WData' isn't recognized."
     
    if "Status_change" <> "Completed or Discard" what i need to write...
  • Shravyashree_10 Profile Picture
    Shravyashree_10 45 on at
    Delegation Warning need to search ID and only user data should visible
    Hi,
     
    The Delegation error is due to StartsWith. 
    Instead, you can use -
    WData:Search( Filter( CMD_NA_Tracker,'Assigen to'=User().FullName ),requestid2.Text,Request_ID)
     
     
    PLEASE GIVE THIS ANSWER A THUMBS UP, IF THIS HELPS AND ACCEPT THIS ANSWER AS A SOLUTION FOR FUTURE REFERENCE!

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

News and Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!

Quick Links

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard

Featured topics

Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans