Hi all. I have a PowerApp overlay on a SharePoint List that's been in place for a few years. I've been asked to add some Lookup information to help with downstream filtering. In this case, the source I need to reference comes to me in the form of an Excel file and has associate information that's not in the Office365 realm. Think, Team Name, Sub-Team, etc. I have the formula worked out to do a Lookup using email as the match from a test set of data. However, the real dataset is 3000+ lines long (after filtering).
I know I can't use Excel given the 2000 row limit. Doesn't seem that a PowerBI dataset is an option. Using a SharePoint list doesn't work because I'll need to update this file weekly and I don't want to do it manually.
So - I'm stuck. I see I have access to Dataverse to a point - I uploaded the table there, but then get privilege error when I try to access the actual Data within the Table.
Is there some other place I can store this formation that PowerApps can reference (without having SQL knowledge)? Something I'm not thinking of? I am open to all ideas! Thanks in advance...
