cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlortie
Regular Visitor

LookUp issue with static excel data

HI Everyone,

 

I am having an issue with what should be a simple LookUp on data with 2 filter conditions on one table.

 

The Excel table is named Strings and I can see data in it from the PowerApps application,  Unfortunately, I am not able to retrieve any data using LookUp. (I have tried playing with eliminating the multiple filters, and I also tried replacing the radio button code with "fr", but no luck).

 

Lookup Code

 

LookUp( Strings, (TextID = "lbl_Home_Welcome") And (LanguageTag = rdio_Home_LanguageChoice.Selected.Code || IsBlank( LanguageTag ))).LocalizedText

// I have also tried

LookUp( Strings, (TextID = "lbl_Home_Welcome") And (LanguageTag = "fr")).LocalizedText

 

The radio control Items are defined as per below and FR is selected.

 

Table( { Label: "English", Code: "en"}, {Label: "Français", Code: "fr"} )

 

 

Strings Table data

 

TextID	Property	LanguageTag	LocalizedText
"lbl_Home_Welcome"	Text	"fr"	"Bonjour"
"lbl_Home_Welcome"	Text		"Welcome"
"lbl_Home_GradualReturn"	Text	"fr"	"Retour progressif en milieu de travail"
"lbl_Home_GradualReturn"	Text		"Gradual Return to the Workplace"
"lbl_Home_ScheduleOfficeEntry"	Text	"fr"	"Planifiez votre présence au bureau"
"lbl_Home_ScheduleOfficeEntry"	Text		"Schedule Your Office Entry"
"btn_Home_Begin"	Text	"fr"	"Commencer"
"btn_Home_Begin"	Text		"Begin"

 

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions

I found the issue - The quotes were causing issue when being loaded from Excel.

 

I just removed them from the spreadsheet that I loaded in the App, and it worked.


Thanks,

Daniel

View solution in original post

2 REPLIES 2
mdevaney
Super User III
Super User III

@dlortie 
I think this code you already shared should work and return a result of Bonjour.

LookUp( Strings, (TextID = "lbl_Home_Welcome") And (LanguageTag = "fr")).LocalizedText

 

Can you please do this for me?  Put this code in the OnSelect property of a button, click the button, then post a screenshot of the result shown in the Collections Viewer?

ClearCollect(colTest, Strings)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

I found the issue - The quotes were causing issue when being loaded from Excel.

 

I just removed them from the spreadsheet that I loaded in the App, and it worked.


Thanks,

Daniel

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (25,448)