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.
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.
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.
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!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.