Lookup function not working

(0) Share

Report

Posted on by RandolphSP

Hello Community,

Recently I have made my first attempt in creating a powerapp.

Let me start by providing my environment.

I have created a sharepoint list that I want to use as a data resource for the app.
It is a list of leads. One of the columns is a date-time field (Volgend_Contact)

I have created an app with a calendar with the help of different resources and now I am struggling with the following :

I have an element that should become visible when the following formula is valid.

!IsBlank(LookUp('Buitendienst_automatic_Leads',_dateSelected=DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days)).company_name)

The whole idea is that the element should show at the corresponding date when Volgend_Contact has a value and hide when this field is empty.

The element is not showing and I am not sure how to adjust the formula.

I hope you can make sense of the story above and point me in the right direction.

Thanks in advance, Randolph

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hallo @RandolphSP ,

I think this is what you need:

!IsBlank( LookUp( 'Buitendienst_automatic_Leads', Volgend_Contact = DateAdd( _firstDayInView, ThisItem.Value ) ).company_name )

All I did was to replace _dateSelected with the name of the column you wish to filter by.

Was this reply helpful? Yes No
RandolphSP 4 on at

Like (0)

Report

Hi @BCBuizer , thank you very much for your response. Unfortunately that did not make the item visible.

Just for clarity I have attached some screenshots. The first screenshot shows that there are three instances (dates) that should show the element.
That gallery was just created for the purpose of finding out if I could find the entries. It will be taken out as soon as it works.

What can I check to make this work?

Thanks in advance

calendar-with-add...

calendar with ite...

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RandolphSP ,

Can you please share the Items property of the temporary gallery you inserted so I can understand how your data source is structured.

Was this reply helpful? Yes No
RandolphSP 4 on at

Like (0)

Report

Sure. here are the screenshots.

Thanks in advance

textlabel-temp-ga...

items-temp-galler...

Was this reply helpful? Yes No