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
Super User

@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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,996)