I’m assisting with the build of an intake form in power apps. Currently we have 2 separate SharePoint lists linked to the power app.

The issue we’re having is with the ID column.

The ID column values are different (although the rest of the metadata is the same) and we need to see how we can align them in the power app.

Here’s an example:

SharePoint List A:

  • ID: 10
  • Title: Consumer

SharePoint List B:

  • ID: 17
  • Title: Consumer

Using the example above, Is there a formula that can be used that will align the ID across the fields in the app?

I understand the ID cannot be changed. Is there a way to link each entry with a common ID?

New contributor
Carter is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

1 Answer 1


You have below two options to manage relationship between two lists in SharePoint.

  1. Use lookups:

You can create a lookup column in 2nd list from 1st list and manage relationship between two lists

Documentation: Create list relationships by using lookup columns

  1. Use custom ID column:

Create a custom column in 2nd list for storing ID column from list 1.

You have to update this column either manually (if less number of items in list) or automate the process using power automate flow by matching Title column in both lists.

Using above ways you will have same ID column in both lists & then you can compare those in power apps.

Your Answer

Carter is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.