Lookup/Filter

(0) Share

Report

Posted on by mutatrt

Hello - I am trying to return a date based on a data card value from a form viewer.

I have employee numbers listed in the data card value, I want to look up their number and have it return a date -

Right now I have the formula as:

Filter(FrontLine,PersonNumber = DataCardValue54,Slicer)

Filter(Source,Column = Data Card Returned from Form Viewer, Date column I want to Return)

Each of the sources/columns are appearing in the suggested items when I type them in. The "help on this error" message is saying that I need two of the same values. I tried to add "DateValue" to the begining of this but it did not help.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@mutatrt

Use lookup to get a specific item
Lookup(FrontLine,PersonNumber = DataCardValue54.Text,Slicer)

Note: Assuming PersonNumber is a text field

Sample
mutatrt 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@StalinPonnusamy

Thank you! I did try this but now the error is saying - "The property on this control expects Text values. The rule produces Table values which are incompatible"
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
What is the field type for PersonNumber?
Can you highlight and see what value you are getting DataCardValue54.Text
mutatrt 28 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it now! The above soultion with .Text worked, thank you very much!