Explanation
In Power Apps, add a data connection to an existing canvas app or to an app that you're building from scratch.
Your app can connect to SharePoint, Common Data Service, Salesforce, OneDrive, or many other data sources.
Note:
Add data source
1. In the center pane, select connect to data to open the Data pane.
2. Select Add data source.
3. If the list of connections includes the one that you want, select it to add it to the app. Otherwise, skip to the next step.

4. Select New connection to display a list of connections.

5. In the search bar, type or paste the first few letters of the connection you want, and then select the connection when it appears.

6. Select Create to both create the connection and add it to your app.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-data-connection

Explanation
Scenario Issue: Users want to be able to see their weekly total time entered from all screens.
A component library provides a centralized and managed repository of components for reusability.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/component-library

Explanation
Scenario: Users report that the customer request number is difficult to interpret. They request that you change the number to a system generated sequential number.
Autonumber columns are columns that automatically generate alphanumeric strings whenever they are created.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/autonumber-fields

Explanation
Graphical user interface, text, application, email Description automatically generated

Step 1: Upload the worksheets to OneDrive
A data source needs to be specified. The data needs to be available.
Step 2: Create a dataflow
Step 3: Create queries for the worksheets
You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power BI Desktop.
Step 4: Add conditional columns to perform checks on the data
Step 5: Append the output of the queries
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows
https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query

Explanation
It is very normal for a developer to build the power automate in one environment and then export that automate & import it to another destination environment.
Exporting our Solution
After validating our flows work in our test environment, we now want to promote it to our production environment. We can export our solution by finding it in our Solutions experience, clicking on the ..., selecting Export.
Graphical user interface, application, Teams Description automatically generated

Reference:
https://flow.microsoft.com/en-us/blog/solutions-in-microsoft-flow/