Power Platform Community Forum Thread Details

Hello,

I'm not able to explore on creating a PowerApps form for Lessons Learnt.

Currently I have a database created into SharePoint List. Usually I extract a excel from one of our org tool and than paste the data to SharePoint every 15 days

My requirement is as below:

All my database i.e. SharePoint fields (columns) should be visible in the form
There will be 5 fields called - Lesson Learnt 1, Lesson Learnt 2, Lesson Learnt 3, Lesson Learnt 4 and Lesson Learnt 5, for which we'll ask users to add data into this fields.
As there will be 1K+ records, so allow users to filter the data as per their needs, so they can enter their comments in the above said fields.
Once they add the comments in Lesson Learnt fields, save the form

Can anyone share a link / PowerApps design form for the above similar requirement.

Thanking you in advance.

Categories:

Building Power Apps

Hi Prem4253,

Thank you for choosing Microsoft Community.

Lessons learnt are a great use case for PowerApps layered over SharePoint, and it’s totally doable with a few thoughtful design choices.

Here's a breakdown of how you can build this out, plus links to some useful resources to help you get started:

🛠️ PowerApps Form Design for Lessons Learnt

1. Connect to Your SharePoint List
Open PowerApps Studio → Create a new canvas app → Connect to your SharePoint list as the data source.

Use a Gallery control to display and filter your 1K+ records.

Add a Form control below or beside the gallery to show selected record details.

2. Display All SharePoint Fields
In the Form control, set DataSource to your SharePoint list.

Set Item to the selected item from the gallery:

PowerFx
Gallery1.Selected
Use the EditForm mode to allow updates.

Include all fields, or customize which ones are visible using the Fields pane.

3. Add Lesson Learnt Fields
Ensure your SharePoint list includes columns named:

Lesson Learnt 1 through Lesson Learnt 5

These will automatically appear in the form if they exist in the list.

You can group them visually or add section headers using labels.

4. Enable Filtering
Add dropdowns, search boxes, or combo boxes above the gallery to filter records.

Example filter formula:

PowerFx
Filter(SharePointList, Title = Dropdown1.Selected.Value)

5. Save Comments
Add a Submit button with this formula:

PowerFx
SubmitForm(EditForm1)

On success, you can reset the form or show a confirmation:

PowerFx
ResetForm(EditForm1); Notify("Saved successfully!", NotificationType.Success)

🔗 Helpful Resources
📘 Microsoft Docs: SharePoint Form Integration in PowerApps

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration

🎥 YouTube Tutorial: SharePoint Form Customization with PowerApps

https://www.youtube.com/watch?v=uNSOqgxwZds

I hope these steps help resolve the issue!

If you need more specific guidance, feel free to ask. If this fixes the issue, please mark as resolved to help others with find it. 🏷️ Please tag me @Robu1 if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future. ❤️ Please consider giving it a Like,

If the approach was useful in other ways.

Happy to help

Superuser/Moderator 2025:S2

Robu 1