Use SQL database values in Sharepoint Custom Forms
Hi everyone, I managed to use a PowerApps custom form to create dynamic dropdowns with my SQL data and the results appear in the dropdowns but when I submit the form only those SQL values show up as invisible (all other non-SQL fields show up fine). I'm using [DB_Name].Customers or Sort(Distinct([DB_Name], Customers), Result) to get the SQL information, but it's just not submitting properly. Is this a problem related to the form's connection to the server? Is there a solution to this issue? Thanks in advance,