SQL LookUp issue on Canvas App

(0) Share

Report

Posted on by godala_vamshi

174

Hello,

I have IT Support sql table(Table A) which has ApplicationMatrixId column, On a label in App I am trying to lookup Application Name from ApplicationMatrix sql table(Table B) based on ApplicationMatrixId on Table A, but for some reason syntax is not recognizing ApplicationMatrixId. Am I doing something wrong?

"App Name: " & LookUp(ApplicationMatrix, Id = ApplicationMatrixId , ApplicationName)

Thank you!

Categories:

Building Power Apps

All responses (16)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
It looks like you are working off of a form, possibly connected to a gallery, right?

If so, ApplicationMatrixId is probably a column name, not a reference to the specific field in a record. Instead try:
"App Name: " & LookUp(ApplicationMatrix, Id = ThisItem.ApplicationMatrixId , ApplicationName)
Hope that helps,
Bryan
godala_vamshi 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCLS776 Yes, that ApplicationMatrixId column is in IT Support sql table, I need to get ApplicationName from ApplicationMatrix table, still error when I use ThisItem.
Thank you!
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Could you share the whole error message? It is not clear what Power Apps is having an issue with
godala_vamshi 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCLS776 For = below is the error.
For ThisItem, below is the error
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm, it is struggling with the reference to that column. Can you share the code that populates the label in the ApplicationMatrixID card in your form, the one that shows the value of 519 in your screenshot? We should be copying that same reference. Also, can you double-check that the IT Support table has a column named "Id"?
Z_Lukowski 216 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,
Letter Sizes matters, in Function you have different name than in form, one have lower letters in id, other have Id,
Possible that is the problem, check it:

BR
Zbigniew
godala_vamshi 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCLS776 For ApplicationMatrixID it is Parent.Default, I tried copying with it reference.

IT Support will have Id but we need to use ApplicationMatrixid to get the name
godala_vamshi 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@Z_Lukowski Its the same, I also tried as you said but same issue.
Z_Lukowski 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Sry, Im little blind I guess,
Can you check what will prompt after you write "ThisItem." (Inntelij should give you some options), try creating inside your context label with ThisItem.ApplicationMatrixID and check what it contains?

Also can we have two checks:
1) Show the navigation left panel to check if we are still in context of Gallery/form with the label
2) Check ApplicationMatrix SQL table to make sure that "ID" is there? Can you refresh your DataSource as well just to be 100% sure?
godala_vamshi 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@Z_Lukowski It doesn't give me any hits when I type ThisItem. Tried refreshing data sources, Yes, ID is there on ApplicationMatrix.