How to show a lookup columns value in the Listview in Powerapps

David Kmann 11 Reputation points
2022-07-11T15:22:35.337+00:00

Hi Community,

I am struggling to show a lookup colums value in the List view within a powerapps gallery.

Foundation:
I have two Lists:
1 - tasks
2 - customers

There is a lookup column in the customers list ("Aufgaben_PowerApp"), that refers to the tasks. I have added the columns Title and ID from the tasks list to the customers list.

Idealy I would like to show the Title for the task of each customer in the gallery. In order to do that, I have added a textfield in the Gallery with the following formular:

LookUp('Aufgaben_PowerApp Vertrieb'; ID = ThisItem.'Aufgabe für Kunde:ID'.Value;Title)

219594-image.png

Somehow it does not work.

Looking forward to some support.

Best,
David

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,213 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,591 Reputation points
    2022-07-12T07:50:54.67+00:00

    Hi @David Kmann ,

    I read your question carefully, but I suggest you start a new discussion in the Power Apps Community on this issue so that you can get more professional help.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Micca 161 Reputation points
    2022-07-12T11:39:54.17+00:00

    You do not need to show the lookup column values within the task list.
    The details are available already within the customer lookup value for the created task.
    This value includes an ID and a title, whereby the ID is the list item ID of the selected customer record.

    Within your customer gallery you could create an icon, which navigates to a different screen with a gallery connected to all tasks.
    In order to know which records should be shown there you can 'carry' this information with you.

    Navigate(ScreenwithTaskGallery,ScreenTransition.None,{CustomerSelectionID : ThisItem.ID , CustomerSelectionTitle: ThisItem.Title})

    For the screen with the gallery showing the tasks you can now make use of a filter (lookup would return one record, not a table of records).

    Filter(ListofTasks, CustomerField.Id = CustomerSelectionID )

    Please note, that this is just meant to point to a potential, general approach.
    You would run in delegation issues with the above setup, risking to not have all tasks been shown.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.