← Al Davies, 250 High Street

Power Apps or a SharePoint list form: which one do you need?

Use the built-in SharePoint list form first and tune it with column and form formatting. Use a Power Apps custom form (Integrate, Power Apps, Customize forms) only when you need things formatting cannot do, such as a profile photo, a different control type or a custom action on save.

What you get with the built-in list form

Every SharePoint list already has a form for adding, viewing and editing items. You do not build it. It follows your columns. Add a column and it shows up in the form.

You can change how it looks without Power Apps:

Formatting uses small pieces of JSON text that you paste in. Microsoft gives copy-and-edit examples. Anyone who can create and manage views in a list can use them, per the pages above. Exact names may differ on your screen.

What a Power Apps custom form adds

A Power Apps custom form replaces the built-in form for that list. You design it in Power Apps Studio. Microsoft's overview page says customization includes the following. The tutorial page also notes that Title and Attachments are predefined cards, locked by default, and need to be unlocked before you change them.

The tutorial shows two typical examples: making the Title field view-only, and hiding a field when another field has a certain value. It also shows how to put a user's profile photo on the form.

To start, open the list, choose Integrate, then Power Apps, then Customize forms. Exact names may differ on your screen. When you finish, you save and publish to SharePoint. The version people see in SharePoint is the most recently published one.

Power Apps with a SharePoint list

Microsoft's overview page says a list from SharePoint or Microsoft Lists can be a data source in Power Apps, either through the Data menu of an app or through the Integrate menu on the list. When you view a SharePoint list, you automatically go to Microsoft Lists, where the Integrate option sits.

Power Apps can also be a full app

A custom form is one use. Power Apps can also build a separate app on top of a list. Microsoft describes this. The generated app lets people browse items, view details, and add, edit or delete records, and it adjusts to phone and tablet. This is a different thing from the form. Use it when people need a mobile-friendly screen for the list, not just a nicer form.

Side by side

Pick the built-in form if

Pick a Power Apps form if

Pick a full Power Apps app if

Licensing and cost

The Microsoft pages above list a subscription to Microsoft 365 and Microsoft Power Platform as a prerequisite for using SharePoint and Power Apps together. What your own plan includes is a question for your admin. Check with your admin before you build, and do it first so you do not build something you cannot share.

A simple list to try both on

Use a small request list, with a Title column named something useful like "Request summary".

Add these columns:

Step 1. Use the built-in form for a week. Add three or four real items.

Step 2. Add column formatting to Stage, so Closed looks different from Received.

Step 3. Configure the list form with two sections: "Request" and "Notes".

Step 4. Write down what annoys people. Be specific, for example "Notes is shown even for simple requests".

Step 5. Only if that list names something the built-in form cannot fix, try a Power Apps custom form.

What to avoid

Honest limits

Column formatting and form formatting change how things look. They add no business rules. The built-in form can show or hide a field by a formula. A Power Apps form adds more rules, custom controls and full layout control, but it takes more skill and more upkeep. Neither one replaces a clear list design. If the columns are wrong, a nicer form will not fix it. For the base list, see "Replace a spreadsheet tracker with a SharePoint list". For an example form that feeds a list, see "How to set up a project intake form in SharePoint". If the people filling it in are outside your team and have no access to the list, see "Save Microsoft Forms answers to a SharePoint list".

When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: $5,000 for one, built in 2 weeks. See "What a SharePoint tracker costs to build". Bring one example of the problem to a free call.

Tell me what's still manual

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: Tools I built

FAQ

Do I need Power Apps to change how a SharePoint form looks?

Not always. Column formatting and list form formatting change the look without Power Apps. The built-in form can show or hide a field by a formula, and form configuration has a read-only field setting. A custom form is for custom controls, full layout control and custom save actions.

Who can use a Power Apps custom form?

Anyone with at least Read or Restricted View access to the list gets the form. People with permission only to specific items do not.

How do I customize a SharePoint list form with Power Apps?

Open the list, select Integrate, then Power Apps, then Customize forms. When done, save and select Publish to SharePoint. The version in SharePoint is the most recently published one.

Is Power Apps included with my Microsoft 365 plan?

Check with your admin. Microsoft's pages list a Microsoft 365 and Power Platform subscription as a prerequisite, but what your plan includes can differ.

Can I use a SharePoint list as a Power Apps data source?

Yes. Microsoft says a list from SharePoint or Microsoft Lists can be a data source, by connecting through the Data menu of an app or through Integrate on the list.

Sources