สร้าง App 📱 ด้วย Power Apps เก็บข้อมูลใน Excel ได้ สำหรับผู้เริ่มต้น

Introduction

This tutorial will guide you through creating an application using Power Apps, a low-code platform that allows users to develop business applications for mobile and web without extensive programming knowledge. You'll learn how to store data in Excel, set up connections, and customize your app for functionality and aesthetics.

Step 1: Prepare Your Files for Power Apps

• Ensure that you have an Excel file ready to store your data.
• Structure your Excel file with clear headers for each column to facilitate data entry and retrieval.
• Save the Excel file in OneDrive for easy access within Power Apps.

Step 2: Sign Up for Power Apps

• Go to the Power Apps website.
• Click on the sign-up option and follow the prompts to create an account.
• Log in once your account is set up to start building your application.

Step 3: Upload Excel File to OneDrive

• Access your OneDrive account.
• Click on "Upload" and select your prepared Excel file.
• After uploading, ensure that the file is accessible and that you can view its contents.

Step 4: Create a Table in Excel

• Open your uploaded Excel file in OneDrive.
• Select the range of cells containing your data.
• Navigate to the "Insert" tab and click on "Table" to convert the data into a table format.
• Ensure that the "My table has headers" option is checked and click "OK".

Step 5: Start Building Your Application

• In Power Apps, select "Create" and choose "Canvas app from blank".
• Choose a layout (tablet or phone) that suits your application's needs.
• Name your application and click "Create".

Step 6: Connect Your Excel File

• In the app editor, go to the "Data" section.
• Click on "Add data" and select "OneDrive".
• Find your Excel file and connect it, ensuring that the correct table is selected.

Step 7: Customize Your Application Screens

• Begin by adding screens to your app for different functionalities (e.g., a data entry screen, a details screen).
• Use the "Insert" tab to add buttons, forms, and labels to your screens.
• Arrange the components logically for user navigation.

Step 8: Format and Display Data

• Use formulas to display data dynamically. For example:

  TextInput.Text = ThisItem.FieldName
  

• Format numerical fields to include commas for better readability:

  Text(YourNumberField, "[$-en-US]#,##0.00")
  

Step 9: Create an Edit Screen

• Add an edit form to allow users to modify existing records.
• Bind the form to your data source and ensure fields are correctly mapped.
• Customize the theme and colors of your app for a cohesive look.

Step 10: Test Your Application

• Preview your app by clicking the play icon in the top-right corner.
• Test functionalities such as adding, editing, and deleting records.
• Check for errors and make necessary adjustments.

Conclusion

You have now created a basic application using Power Apps that connects to an Excel file for data storage. This guide covered the essential steps from preparation to testing. As a next step, consider exploring additional features such as integrating Power Automate for automation or Power BI for data visualization. Happy app building!