SharePoint Columns - ID Records from Different List

I have two separate lists, with one recording active items to be updated and worked, and the other list is intended to collect data as an artifact/intake form. However, with limitations of Power Auto...