Filter by name and get the last day.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm using excel as DB.

i'm trying to find the last day that is like to an user.
i'm using this sentence, but isnt working.

Auditoria is my Table
Usuario is my "person name"

inp_Nome_Txt is name i'm looking for

Data date column

First(
 SortByColumns(
 Filter(Auditoria; Usuario = "inp_Nome_TXT.Text");
 "Data";
 Descending))

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Does this exact value exist in your Excel sheet? Does it actually have .Text at the end? Ensure the match is exact 🙂

inp_Nome_TXT.Text

Excel has a 500 row limit when using the FILTER function by Default. You can bump it up to 2,000 rows by going to File > Advanced Settings > Delegation Row Limit and changing to 2,000.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Actualy the inp_Nome_TXT is the name of my labe, and the .Text is to get the value that is inside
Lable name: inp_Nome_TXT
inp_Nome_TXT.Text = "John".
i'm not being rude, since english isnt my first language i'm just trying to be as much clear as i can.
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Thank you for the additional language. Your English is very good indeed 🙂

I would suggest making this small change: inp_Nome_TXT.text is not required to be within quotation marks.

First( SortByColumns( Filter(Auditoria; Usuario = inp_Nome_TXT.Text); "Data"; Descending ) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Idk why, but still doent work.
@mdevaney
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

There is an red error icon on the control. Please share the error message. The error message will tell us what went wrong.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@mdevaney
Value Text expected.
The propriety in this "control" expect a text value.
The rule make a value Record, which is incompatible.
How to fix.
Change the rule to produce a value {0}

First( SortByColumns( Filter(Auditoria_2; Usuario = NomePessoa.Text); "Data"; Descending ) )

I'm Currently using this formula.
i'm using a sharepoint now as my DB, 40 rows at max

You can see my columns name in the SS as well (data = Date (Date is an sigle line text property) )
Verified answer

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous
You must choose a column to display in the label. Do this by changing your_column_name in the code below.

First( SortByColumns( Filter(Auditoria_2; Usuario = NomePessoa.Text); "Data"; Descending ) ).your_column_name

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Omg, i cant believe it, you are the G.O.A.T, tnx @mdevaney. It solved my problem.