Dataverse - Error in Filtering Criteria

(0) Share

Report

Posted on by Jawaharprem

263

Hi Team,

need to filter only users name in 'Assigen to' and only Assigned list to show and search option by request id, i worked on some formula but getting errors..

ClearCollect(
    colProcessData,
    Filter(
        'Assigen to',
        Assign_To_Person.Value = "Assigned" &&
        User().FullName = Value &&
        (
            !IsBlank(searchrequestid2.Text) && StartsWith(Request_ID, searchrequestid2.Text) ||
            IsBlank(searchrequestid2.Text) && Request_ID <> ""
        )
    )
) 
Thanks
Jawahar

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

LarsDePauw 7 on at

Like (1)

Report
Copy link

Link copied!

(something went wrong when submitting my post so it might show double)

1. It is better to put the column you want to check to the leftside, so 'Value = User().FullName' instead of 'User().FullName = Value'.

2. I optimized your searchrequestid check

3. You first check on the value of the column 'Assign_To_Person', which means your datasource has objects, which have at least the column 'Assign_To_Person', which also are objects, which have a Value property, but after that, you check if the Value of your datasource objects is the same as the name of the logged in user, which means your datasource are only strings. Did you mean to check something like 'Assigned_Person'.Value = User().FullName' ?

What is the your datastructure?

ClearCollect(

colProcessData,

Filter(

'Assigen to',

Assign_To_Person.Value = "Assigned"

&&

Value = User().FullName

&&

If(IsBlank(searchrequestid2.Text), Request_ID <> "", StartsWith(Request_ID, searchrequestid2.Text)

)

)

)

Was this reply helpful? Yes No
Jawaharprem 263 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Thanks for your time, the below mentioned codes ok without error but data is not shown,

Code1 ClearCollect(colProcessData,Filter(CMD_NA_Trackers, Text(Assign_To_Person)="Assigned" && User().FullName && ( !IsBlank(searchrequestid2.Text) && StartsWith(Request_ID,searchrequestid2.Text) || IsBlank(searchrequestid2.Text) && Request_ID <>""))) Code2 ClearCollect(colProcessData, Filter(CMD_NA_Trackers, Text(Assign_To_Person) = "Assigned" && (!IsBlank(User().FullName) && Text(Assign_To_Person) = User().FullName) && ((!IsBlank(searchrequestid2.Text) && StartsWith(Request_ID, searchrequestid2.Text)) || (IsBlank(searchrequestid2.Text) && Request_ID <> ""))))

Thanks

Was this reply helpful? Yes No
Suggested answer

Jawaharprem 263 on at

Like (0)

Report
Copy link

Link copied!

Hi,

for filter only for name or id for dataverse, go to gallary select items and use this code its working.

Was this reply helpful? Yes No