Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Suggested answer

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

Posted on 12 Dec 2024 09:38:38 by 178
 
 
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
 
 
 
  • WarrenBelz Profile Picture
    WarrenBelz 143,591 on 14 Dec 2024 at 06:27:01
    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 27 on 13 Dec 2024 at 07:42:39
    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 178 on 12 Dec 2024 at 13:12:20
    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 27 on 12 Dec 2024 at 12:08:23
    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 178 on 12 Dec 2024 at 11:51:44
    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 12 Dec 2024 at 11:37:26
    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 178 on 12 Dec 2024 at 11:14:47
    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 27 on 12 Dec 2024 at 10:24:08
    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

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard