Show text with LookUp

[kinghnvn]

Hi all,

I have a DeskInfo SharePoint list and I set icon on map for each desk

When user book a desk it store information in BookedInfo sharepoint list

If desk is booked and when I click on the icon to select a desk. How can show text with Employee booked the desk?

Text Result -> Employee: TienaVu

@StalinPonnusamy 

[AJ_Z]

What columns exist in BookedInfo. is the DeskName or any unique value (e.g. guid or number or name) the same across both of them. Is there a columns linked to the colleague. If so you could LookUp(BookedInfo, DeskName = DeskName).Colleague . if there is a data filter you would need to include that in the lookup. Let me know if this needs a bit more discussion and it would help if i know what colums we have in bookedinfo

[PabloRoldan]

Hi,

Connect your list as data source

Add a gallery control and in Items Property set DeskInfo

Select first row in the gallery and add your image,

the select the image and OnSelect Action paste this code

Notify(ThisItem.Employee)

 If you click that image an notification will pop out

regards

if it was helpful please consider mark it as answer ✔✔

[kinghnvn]

What columns exist in BookedInfo. is the DeskName or any unique value (e.g. guid or number or name) the same across both of them.

->

DeskInfo list

ID: number

Title: Text

BookedInfo list

Title: Text

Employee: Text

When I click on the icon it will show desk name (Desk 018) (in title column/ DeskInfo)

When I booked the desk, it will record in Title column (BookedInfo) with Employee name (TienaVu)

I want to show the text when another user click on this icon with the same desk name, it will show text "Booked by employee: TienaVu"

[kinghnvn]

I have two SharePoint list and the DeskInfo list have no Employee columns so the code could not run.

DeskInfo list

ID: number

Title: Text

BookedInfo list

Title: Text

Employee: Text

[StalinPonnusamy · Accepted solution]

Hi @kinghnvn 

Need to use Lookup to get employee information for the desk that booked

LookUp(
    SPList,
    BookDate = BookingDate.SelectedDate && Office.Id = MainGallery.Selected.ID
).Employee.DisplayName

To Avoid Delegation

With(
    {
        item: Filter(
            OfficeBooking,
            BookDate = BookingDate.SelectedDate
        )
    },
    LookUp(
        item,
        Office.Id = MainGallery.Selected.ID
    ).Employee.DisplayName
)

In this example, I selected desk 3 booked by "Diego S"

In your case, you need to use StartDatetime and EndDatetime with Desk ID.

Thanks,
Stalin - Learn To Illuminate

[kinghnvn]

that's great! thank you so much