web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a collum in a l...

Power Apps

Answered

Filter a collum in a list and get a value from another collum

(0) Share

Report

Report

Posted on by arturtymchenko

16

My problem is

I need to get last item from a collum, for that i use

Last(Teste).RNC

, but I need the list to show only values for a certain name

User().FullName

I know I can use Filter(), but I can't get it to work.

Last(Filter(Teste;User().FullName = Tec_Emissor)).RNC

RNC is an integer

tks.

Categories:

Building Power Apps

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What error are you receiving?
arturtymchenko 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush my powerapps is in portuguese, "em branco", so either it would be empty or blank

but, there is a Value for this situation, and it should return "1"
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I would maybe try, in a label or something, typing

User().FullName

so we can be sure that the format of it there, and in the Tec_Emissor column are identical. Because if you are not receiving an error, just a blank return, that would suggest your filter criteria is not being met
arturtymchenko 16 on at

Like
a
(0)

Report
Copy link

Link copied!
I tried with the exact name patched in the collum and it returns as blank,
I think this is not the right way to only show
User().FullName
for the
Last().RNC
function
Verified answer

arturtymchenko 16 on at

Like
a
(1)

Report
Copy link

Link copied!

@TheRobRush
You won't belive what it was, instead of giving padding, I added actual space in text, changed to padding, and the issue was solved
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Haha yah that would do it

Join the conversation