Lookup to another list

Copper Contributor

Hi there, new guy in this forum. And I was wondering if this is possible:

 

have a complex scenario where the data change very often and I can not connect my powerapps to my data source directly for many reasons. So basically I have to receive an excel file once a month with all the updates, then I do some cleanup in the file. Change to table, set the columns format etc. Once everything is done Then  I copy / paste the data into an existing file. The file is connected to my power apps to get the values. the file is in my onedrive and I am using the excel business connector. So now you can imagine the issues with delegation warning, filtering, performance, etc.

 

Now, why I am doing this? because I need to add some lookups conditions. I need to check is a new entry is added and is not in my mirror table.

 

I need the values in my mirror table to get the latest updates from the source file.

 

and I need to add some extra values "columns" to my mirror records and keep it.

 

I have tried Excel, Share point and Dataverse with terrible results.

 

In the below diagrams you will see a small representation of my data.

 

What I need is to see if this could be achieve using two Share point list.

 

Thanks in advance for any help.

 

Regards,

 

 

sajarac_0-1628180521604.png

 

 

 

 

sajarac_1-1628180545120.png

 

 

sajarac_2-1628180561165.png

 

0 Replies