
My source data is in a SQL table(read access only) and I have created a SharePoint list that matches the source table, but with 3 additional status columns. I want to build an application that allows users to update the status on projects. However I need the application to first pull from the SQL table and sync it with the SharePoint list. I've tried Power Automate and have been unsuccessful because there are date columns. Is there a way to do this through Power Apps?
You'll have the same issue with the date columns in Power Apps that you have in Power Automate. For the sync portion of this Power Automate is a better solution that Power Apps. Please post your issue with PA in the Forums and send me a link. I'll try to coach you through the issues you are having with dates.