Power Platform Community Forum Thread Details

In short, i am making a canvas app to automate the process when a new employee starts.

I already did it using sharepoint, but now i have to convert it to dataverse. In sharepoint i had 2 lists: List1 all applications and access needed split up by the job description and the department (ie marketing needs facebook and instagram OR finance needs accounting software X)
List2 is just all apps listed with a small summary of what the app is (i only need the name in list1)

I used lookup columns to add those app Titles to A field in LIST1. See pic's beneeth

Now i would like to do this in the same way using dataverse, but when i click lookup i can't select any other table i have created in this solution. See pic's beneath:

As you can see, none of the tables on the left are selectable.

The reason it needs to be constantly connected is because it constantly changes.

Apps come and go

Any Help/ Tutorial would be much appreciated 😄

EDIT: the reason i want to lookup to a table in the same solution in stead of a table in the "environment" is because i need to be able to export and import this solution to multiple small companies, so when i export the solution it needs to export all the used lists as wel.

That is also the reason i switched from sharepoint to dataverse so the tables export with the sollution

Categories:

Microsoft Dataverse with Power Apps