Power Platform Community Forum Thread Details

I have a dataverse database with several columns, i am trying to extract the last submitted record from the database and show the records (Name, Phone Number, ID, Description) in my power app gallery. i tried to filter the dataverse database using two conditions :

1. when the ID is less than 1

2. when the Department = a specific Department

I used the code below to execute it but it's not fetching the prior datas as expected:

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});

Categories:

Microsoft Dataverse with Power Apps