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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,866)