so we have a power app that collect user data, we use sharepoint online as datasource. I want to know if we don't have on prem gateway, what is the best way to move data from sharepoint item list to on premium sql server?

I tried to move the screen use patching into a user defined function and then called the function from the various screens in my app. The patch is writing to a SharePoint list. I also have the App.OnError writing to another list. After changing the Screen Use patching I started noticing a bunch of errors stating that conflicts exist withe the changes on the server. Has anyone gotten this to work in a user-defined function?

So I'm using one of the premade screen templates (sidebar) and experiencing some weird results on how the Main container is being displayed on preview. I'm using all the available space in my gallery and container - but when I click preview, there's all this extra space on the right. I can supply all my container info if needed... all the other containers seem to work as expected on the page. it's happening on 2 different screens.

How to sign up/ pay for courses/ I watched the brief 6-minute video on Power Platform Admin and Governance and I'm interested in viewing the full course.

I am wondering if anyone has done a filter a SP List and used a variable, say from a With statement, as the column name to filter for certain criteria (and gotten it to work). Something like: With({FilterCritera:DropDown1.Selected.Value}, ClearCollect(colEvidenceCollection, Filter(SPListName, FilterCriteria = "Yes")))