Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Binding Error in Form DataSource Item

I am doing a rather typical form situation.  The form source is one SQL View.  The following statement yeilds a Binding Error.  I have no idea what it is, but the statement is correct.  I have used very similar statements for other forms.  Please advise.

 2019-01-13 18_48_29-NVIDIA GeForce Overlay.png

LookUp('[dbo].[VIEW_KDL_WITH_SW_DOCID]',DrawingNumber=CurrentPartNumber And Text(RevisionNumber)=(CurrentRevision))


Community Support Team
Community Support Team

Re: Binding Error in Form DataSource Item

Hi @martinav ,

Can you show me your structure of your SQL View ?

Can you show me your base tables of your SQL View ?


The error message should be caused by your data source.


I made a test. There’s no issue on my side.




Please check if the column of your base table is changed .

Please check if the base table has been deleted .




Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Binding Error in Form DataSource Item



Sure.  This is an old table I have been using for quite a while.  The statement is a little busy because of crossing to a different instance.  But, the table resolves fine.


SELECT        TOP (100) PERCENT [Kelso-Prod].dbo.tbl_Drawings.DrawingNumber, [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionNumber, [Kelso-Prod].dbo.tbl_Drawings.Title, [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionNotes, 
                         [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionDate, [Kelso-Prod].dbo.tbl_Drawings.Project, [Kelso-Prod].dbo.tbl_Drawings.IsActive, [Kelso-Prod].dbo.tbl_DrawingRevisions.DrawingFile, 
                         [Kelso-Prod].dbo.tbl_Drawings.Component, [Kelso-Prod].dbo.tbl_Drawings.DateDrawn, dbo.SWPDM_DocumentIDFromPartNo.DocumentID
FROM            [Kelso-Prod].dbo.tbl_Drawings INNER JOIN
                         [Kelso-Prod].dbo.tbl_DrawingRevisions ON [Kelso-Prod].dbo.tbl_Drawings.idDrawing = [Kelso-Prod].dbo.tbl_DrawingRevisions.idDrawing INNER JOIN
                         dbo.SWPDM_DocumentIDFromPartNo ON [Kelso-Prod].dbo.tbl_Drawings.DrawingNumber = dbo.SWPDM_DocumentIDFromPartNo.ValueText COLLATE SQL_Latin1_General_CP1_CI_AS
ORDER BY [Kelso-Prod].dbo.tbl_Drawings.DrawingNumber, [Kelso-Prod].dbo.tbl_DrawingRevisions.RevisionNumber DESC

2019-01-14 08_30_52-KT-ES-01.Martin-Test_OLD - dbo.VIEW_KDL_WITH_SW_DOCID_ - Microsoft SQL Server Ma.png2019-01-14 08_31_11-KT-ES-01.Martin-Test_OLD - dbo.VIEW_KDL_WITH_SW_DOCID_ - Microsoft SQL Server Ma.png


Level 10

Re: Binding Error in Form DataSource Item

adding in @GregLi to review and assist. 



Super User
Super User

Re: Binding Error in Form DataSource Item



Thats fantastic.  Thanks for that!

Helpful resources


New Badges

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (4,692)