Aug 05 2021 09:20 AM - edited Aug 05 2021 09:22 AM
Hi there, new guy in this forum. And I was wondering if this is possible:
I 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,