cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Coletteb425
Level: Powered On

Why does this LookUp formula not work??

So I am fairly new to Powerapps but I thought this was an easy one I was it to pull through the value of which enquiry type ranked 1st 2nd and third into a label. Please see attached a small snippet of data and formula I used. 

4 REPLIES 4
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Why does this LookUp formula not work??

What is the error that you get when you use that LookUp expression? If you click on the formula bar, the error should appear as a tooltip above the cursor.

One thing that may be happening - dates in Excel don't play very well with PowerApps without some work. The blog post at https://powerapps.microsoft.com/en-us/blog/working-with-datetime-values-in-sql/ talks why this is the case for SQL Server tables, and the reason is the same for Excel tables as well.

Coletteb425
Level: Powered On

Re: Why does this LookUp formula not work??

I dont get an error it just doesnt bring the value across. I have tried changing the excel format for the date and the format for the date picker is exactly the same "dd/mm/yyy" I have tried it without the date and it still brings back no value. This is a label and its in the text properties. Its so frustrating! Its the last part of the app. 

PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Why does this LookUp formula not work??

Unfortunately changing the date format in Excel won't change how Excel exposes the data to PowerApps - it will still expose it as a Date/Time value without any time zone information, and PowerApps will interpret it as if it was in UTC (GMT) - as I mentioned in the blog post from my previous reply.

You can adjust the date to account for the time zone deviation, and with that you should be able to get the date comparison working:

LookUp(
    Top3Table,
    DateAdd(Date_x0020_T3, TimeZoneOffset(Date_x0020_T3), Minutes) = DatePicker1.SelectedDate
        And Partner_x0020_T3 = Dropdown1.Selected.Value
        And Rank_x0020_T3 = "1",
    Enquiry_x0020_type_x0020_T3)

Hope this helps!

Coletteb425
Level: Powered On

Re: Why does this LookUp formula not work??

Hi thank you so much for your reply and that does make sense but for some reason it still doesnt work. Again no errors just no data coming across. 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 52 members 4,503 guests
Please welcome our newest community members: