Power Platform Community Forum Thread Details

I have an app that is doing a comparison of an outside file of people and identifiers such as an ssn to our main client database table and trying to do a match (with ssn, names, addresses). I have a scoring system that scores a 3 on a SSN match as this would be a 100% match. Names and addresses are lower scores. Here is the ITEMS property of the gallery.

SortByColumns(
 GroupBy(
 AddColumns(
 'Property Records',
 "FirstName",
 First(Split(Name," ")).Result,
 "LastNames",
 First(LastN(Split(Name," "),2)).Result),
 "Name",
 "FirstName",
 "LastNames",
 "Social_x0020_Security_x0020_Numb",
 "TransType",
 "GroupedRecord"
 ),
"Name",Ascending,"TransType",Ascending)

Property Records is a connection to an On-Prem SQL instance and going through a data gateway. The records coming in are daily records from a csv file and at most contain a hundred records. The main client table in the SQL instance is 70K+ records.

In the Item Template of the gallery I have a label with the cumulative score and a label whose Text property is :If(CountIf(ISK_Clients,ssn=ThisItem.Social_x0020_Security_x0020_Numb)>0,"SSN Match","No SSN Match").

When we run the app, it literally takes around 5 to 10 minutes to even display data needed. Someone mentioned this URL, however it is a 404 error message now: https://powerapps.microsoft.com/en-us/blog/considerations-for-optimized-performance-in-power-apps/#:~:text=%20Considerations%20for%20optimized%20performance%20in%20Power%20Apps,Apps%20applications%20with%20diverse%20options%20of...%20More%20

I was thinking of instead of on-prem using a SharePoint list or Dataverse for the main Client database where I can import or use Power Automate to map a csv file coming from a Stored Procedure. Would that improve performance?

I need to have this app responsive, but the end user understandably does not want to wait ten minutes for data.

Thanks for the information and help

Categories:

Building Power Apps