Share
ReportHi All,
Here is the dilema I am struggling with. I am fairly new to PowerApps and learning daily but have not been able to figure this one out. I am building a form for my company in PowerApps to reside in a SQL Server. We have a data entry person who currently does this in excel in a massive spreadsheet. It's a headache because it crashes computers constantly. Anyhow, alot of the data entry is repeated. Most of the data is inputed into Saleforce on the frontend. I want to import that data on an automatic basis (meaning each new client generates a new form to fill out) (almost like an inbox within PowerApps to be completed by that data entry person) , have that backfill the PowerApps form for each line item in Salesforce and then have that data entry person double check and fill in (accounting stuff) the remainder of the form. From there I want to house it into a SQL server, so that others can just use the "Get Data" function in Excel and pull it in from the SQL server.
PowerApps has a connector for all these, however it is not quite clear how to get that import/export feature and how to establish what Salesforce is supposed to do. Not sure if I need to involve Microsoft Flows in order to do this. I am on a deadline so anything helps. Can anyone help with this issue, it woukld help me tremendously. Also learned that I needed a primary key on the SQL server finally, that was a whole day wasted trying to figure that out. Thanks for the help! Cheers!
All responses (
Answers (
714
