Answered

PowerApps place label with value from another card where ID's match

(0) Share

Report

Posted on by GregGuth

I am trying to place a label on a form where I pull the value from another form in the same app and place it when their ID's match. I have the query worked out but am unsure of how to format this in PowerApps so the label displays this queries result.

Here is my query: ('[Administration].[Address_Type]'.name) Where ('[Administration].[Address_Type]'.id) = DataCardValue15

I am trying to display the Address_Type name where the ID matches the current screen (Class) ID.

In the case above the ID is 1 so based on the query and the Type list shown below, the text should read "Default"

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

eka24 20,923 on at

Like (1)

Report

Use this structure:

LookUp(Datasource,Column= Value(DataCardValue15.Text), ColumnToReturn)

So try;
LookUp(
'[Administration].[Address_Type]',id = Value(DataCardValue15.Text),Address_Type)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
GregGuth 57 on at

Like (0)

Report

Thank you! You did an excellent job of explaining how and when to use the "LookUp" function!

This should be a great resource for others to use and follow.
My final solution was:
LookUp('[Administration].[Address_Type]',id=Value(DataCardValue15.Text),name)

Was this reply helpful? Yes No