Copilot in Power Apps can assist with some of the tasks you mentioned, particularly in simplifying the process of connecting data sources and configuring forms. However, specific functionalities like cascading dropdowns or connecting multiple SharePoint lists may still require manual setup or custom code depending on the complexity of your requirements.
- Cascading dropdown based upon another column: This typically requires some manual configuration to set up the logic for the dropdowns, as Copilot may not fully automate this process.
- Connectivity of multiple SharePoint lists in one form: While Copilot can help suggest relevant fields and streamline the process, integrating multiple lists into a single form may still need manual adjustments.
- Connectivity of multiple lookup columns in one form: Similar to the above, while Copilot can assist in suggesting fields, the setup for multiple lookup columns usually requires manual configuration to ensure they work as intended.
In summary, while Copilot can help speed up the process and suggest relevant configurations, some tasks may still require manual coding or adjustments to achieve the desired functionality.