Unanswered

I can't get a simple lookup function to work

(1) Share

Report

Posted on by RCWh3rry

I have a connected table Named Current_Session. I have a Text Label on my canvas app where i want the text to = Lookup(Current_Session, SessionRef = 1).SessionName. This returns Blank. What am I possibly doing wrong?

Table Name = Current_Session

SessionRef

SessionName

1	Session: 45698.36985; REBAG A

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

cha_cha 4,932 Moderator on at

Like (0)

Report
It's because the LookUp Returns a Table even if it just contains 1 row. For you to retrieve that row and use its property Session name, Use the First command. Below should do it.

First(Lookup(Current_Session, SessionRef = 1)).SessionName

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@cha_cha

You are wrong. LookUp() returns the first record in a table that matches the criteria. You are thinking of Filter() which returns a table. Your formula should work or you can try Lookup(Current_Session, SessionRef = 1, SessionName)

Was this reply helpful? Yes No
RCWh3rry 12 on at

Like (0)

Report

so my first issue seems to be SessionRef = 1, it gives me an error saying "Incompatible types for comparison. These types can't be compared: Text, Number.", However SessionRef is the column name in the data table and 1 is the first value in that column. do i need reference the column name within the formula differently?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@RCWh3rry

The problem is that your table considers SessiionRef to be text. Try Lookup(Current_Session, Value(SessionRef) = 1).SessionName

Value() changes SessionRef to a number so it can be compared.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

@Drrickryp Thanks for pointing that out. I'm very dependent on PowerApps suggestions and auto complete.

Was this reply helpful? Yes No
RCWh3rry 12 on at

Like (0)

Report

That does fix the error in the formula, however it still returns the formula = Blank. I'm lost as to why it will not return the value in the SessionName column?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@RCWh3rry

To troubleshoot this, put a datatable on your screen and set it's DataSource to Current_Session and see what values you get in the SessionName column. Please specify the type of datasource you are using and the type of column SessionName is.

Was this reply helpful? Yes No
RCWh3rry 12 on at

Like (0)

Report

so the data source is an excel spreadsheet added through OneDrive. I added the data table to the screen, added the filed SessionRef (which says its a text field), but it says there is no data to display.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@RCWh3rry

Excel is a terrible data source and I suspect that it has become corrupted in some way. Once a table has been imported, any changes to the schema in Excel will corrupt the table.

Delete the current table from Powerapps. Go back to Excel and copy the data to a new table without the last column (the one added PowerApps). Set the column types to either Text or Number, make sure there is a value in the first row below every column header even if you have to sort the table and re-import the data back into PowerApps. Consider moving the data to SharePoint and watch Shane Young's video https://www.reddit.com/r/PowerApps/comments/l5n0q1/video_learn_why_excel_is_a_terrible_data_source/

Was this reply helpful? Yes No
RCWh3rry 12 on at

Like (0)

Report

I removed the table in the excel sheet and re-added it. I also removed the data source from the power app and re-added it through excel online instead of through Onedrive. this fixed the issue and it works now. Thank you!

Was this reply helpful? Yes No