Dynamic powerapp

Hello akash0800,

You can dynamically change the fields in the form based on the selected year by using the PowerApps formula language. Here are the steps to accomplish this:

1. Create a drop-down control to select the year in the form.

2. Create a data card for each field you want to display in the form and set their visibility based on the selected year.

5. Use the context variable in the "Default" property of the data cards to display the appropriate data for the selected year. For example: LookUp(SharePointList, EmpID = Form1.LastSubmit.EmpID, SelectedYear)

By using these steps, you can dynamically change the fields in the form based on the selected year, without having to create a separate form for each year.

You can also store the data for each year in a separate row in the SharePoint list, using the "EmpID" and "Year" columns as a composite key.