Power Platform Community Forum Thread Details

Hello Power App Team,

While Migrating to SharePoint on - premise to SharePoint Online we faced many challenges, There was a standard limitation of Lookup column problem is occurred, to overcome we have made a choice columns. Therefore schema got modified and worked.

With the help of power automate imported the data successfully from on premise through excel, but we could not able to manage those auto incremented Id, so we have created a new number column named as (ParentID) to capture those unique auto increment id from older list.

Now those unique ids (ParentID) are mapped with many tables as a foreign key, but lookup column only see the unique auto incremented ID that is default behavior of lookup column . Looking to map lookup column with that ParentID.

Your Suggestion are welcoming here.

Categories:

Connecting to Data

Hi @khaleelN, This is more SharePoint related query rather than PowerApps. For SP there is dedicated community: https://techcommunity.microsoft.com/t5/sharepoint/bd-p/SharePoint_General

However, I will try to answer this here: When you create LookUp column in SP list then while creating the column there is option shown below:

Example: I have ListA and ListB

In ListA, I am creating a Lookup column with name PID which will lookup in ListB for column ParentID as shown in above screenshot.

If this does not help then please post your query on SharePoint forum for quick response

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

.