Unanswered

Filtering a dataverse table using two distinct conditions

(0) Share

Report

Posted on by Advok8

This is my first time using Dataverse on Power App, I have a gallery that is displaying an item from a collection, i want to clear the collection and Update the record from the database by filtering the record based on two conditions (i.e I only want to display the record that meets two conditions).

I wrote the code this way but its not pulling out any of the records:

Clear(tempdata); Reset(gallerypositionsdefault);

Collect(

tempdata,

Filter('Position Holders',erms_rou_id=Value(txtregunitid.Text) && erms_eid = Value(TextInput3_6.Text)-1 ));

UpdateContext({varShowPopup:false});

I would appreciate guidance from anyone. Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

codevenkat 126 on at

Like (0)

Report

Hi @Advok8 ,
See this video it helps https://www.youtube.com/watch?v=Cu8pDo6WpRI
If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hello @Advok8,

You are very near to it.

Try making this small change to make it work. Let me know if you need have any quereis.

ClearCollect(tempdata,Filter('Position Holders',And(erms_rou_id=Value(txtregunitid.Text), erms_eid = Value(TextInput3_6.Text)-1)));

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No