I have a primary key Table value in Dataverse.
The value for the record I am trying to retrieve is 0001
I have tried doing a lookup and a Filter, but neither seem to fetch any data.
In my items property of my form I have
Lookup(Tablename, PersonID = 0001)
or ideally I want to filter it by a variable value that has 0001
Lookup(Tablename, PersonID = variablevalue)
I also tried filter, but that does not appear to work either.
These statements seem to work against Sharepoint and SQL Server, but not Dataverse it seems.
Any help appreciated.
