Lookup to another list

%3CLINGO-SUB%20id%3D%22lingo-sub-2616216%22%20slang%3D%22en-US%22%3ELookup%20to%20another%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616216%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20new%20guy%20in%20this%20forum.%20And%20I%20was%20wondering%20if%20this%20is%20possible%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%26nbsp%3B%3C%2FSPAN%3Ehave%20a%20complex%20scenario%20where%20the%20data%20change%20very%20often%20and%20I%20can%20not%20connect%20my%20powerapps%20to%20my%20data%20source%20directly%20for%20many%20reasons.%20So%20basically%20I%20have%20to%20receive%20an%20excel%20file%20once%20a%20month%20with%20all%20the%20updates%2C%20then%20I%20do%20some%20cleanup%20in%20the%20file.%20Change%20to%20table%2C%20set%20the%20columns%20format%20etc.%20Once%20everything%20is%20done%20Then%26nbsp%3B%20I%20copy%20%2F%20paste%20the%20data%20into%20an%20existing%20file.%20The%20file%20is%20connected%20to%20my%20power%20apps%20to%20get%20the%20values.%20the%20file%20is%20in%20my%20onedrive%20and%20I%20am%20using%20the%20excel%20business%20connector.%20So%20now%20you%20can%20imagine%20the%20issues%20with%20delegation%20warning%2C%20filtering%2C%20performance%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20why%20I%20am%20doing%20this%3F%20because%20I%20need%20to%20add%20some%20lookups%20conditions.%20I%20need%20to%20check%20is%20a%20new%20entry%20is%20added%20and%20is%20not%20in%20my%20mirror%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20the%20values%20in%20my%20mirror%20table%20to%20get%20the%20latest%20updates%20from%20the%20source%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I%20need%20to%20add%20some%20extra%20values%20%22columns%22%20to%20my%20mirror%20records%20and%20keep%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20Excel%2C%20Share%20point%20and%20Dataverse%20with%20terrible%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20below%20diagrams%20you%20will%20see%20a%20small%20representation%20of%20my%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20need%20is%20to%20see%20if%20this%20could%20be%20achieve%20using%20two%20Share%20point%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sajarac_0-1628180521604.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300881i274D942FE1B5ACFB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22sajarac_0-1628180521604.png%22%20alt%3D%22sajarac_0-1628180521604.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sajarac_1-1628180545120.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300882iC6CA2D9C3226C669%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22sajarac_1-1628180545120.png%22%20alt%3D%22sajarac_1-1628180545120.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sajarac_2-1628180561165.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300883i4CFBE301449B2A4D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22sajarac_2-1628180561165.png%22%20alt%3D%22sajarac_2-1628180561165.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2616216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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