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)
Solved! Go to Solution.
@godala_vamshi One of this should work:
LookUp(ApplicationMatrix, Id = Value(DataCardValue1.Text), ApplicationName)
LookUp(ApplicationMatrix, Id = DataCardValue1.Text, ApplicationName)
LookUp(ApplicationMatrix, Id = DataCardValue1.Value, ApplicationName)
Also I see that what you basicly using is Left Join from SQL, if you want to explore topic further its possible to recreate LEFT JOIN capabilities in Power Apps Directly, here Ive created video about this topic:
A) LEFT JOIN:
B) INNER JOIN:
This is only optional, but may be helpful depending on your needs regarding Joining those collections
Hope that helps,
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,
@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.
Could you share the whole error message? It is not clear what Power Apps is having an issue with
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"?
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:
@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
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?
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.