Power Platform Community Forum Thread Details

Hi everyone,
I'm currently working on a Canvas app where I'm in the process of migrating its data source from a SharePoint list to a Dataverse table. Both the SharePoint list and the Dataverse table have similar names and structures, which I thought would make the transition smoother.
In my app, I have a form screen that utilizes a LookUp formula to fetch specific data. When the data source was the SharePoint list, the formula looked like this:

LookUp(
    SharepointList,
    SelectedItemID = ID
)

This formula worked perfectly fine without any issues.
However, after changing the data source to the Dataverse table and updating the formula to reference the new table, like so:

LookUp(
    DatabaseTable,
    SelectedItemID = ID
)

I encountered an error. The app now tells me that "ID is a control data type," and the formula refuses to work as expected.
I'm a bit puzzled by this error since I expected the transition to be straightforward given the similar structure and naming of the SharePoint list and the Dataverse table. I've double-checked the names and structures to ensure they match, but the issue persists.
Could anyone provide insights or guidance on how to resolve this issue? Is there a specific adjustment or consideration I need to make when using the LookUp formula with a Dataverse table compared to a SharePoint list?
Any help or suggestions would be greatly appreciated. Thank you in advance for your time and assistance!

Categories:

Connecting to Data