Practical help from Quintera

Practical Power Apps and Power Automate guides

Find the problem you are working on and follow an example. These free Microsoft 365 guides explain common app and automation issues, show what to try and help you check the result.

01 / Practical guide

Find the problem you are working on

Working across other tools? Browse the wider automation library for Zapier, Make, n8n and AI workflow examples. This collection focuses on Power Apps, Power Automate and Microsoft data sources.

Power Apps · Defaults and forms

Power Apps defaults and Reset: five worked examples

Set dropdown defaults, clear text inputs, match combo box records and reset forms. Follow five examples with made-up data and expected results.

See the examples

Power Automate guide

Power Automate dates and time zones: 5 worked examples

Fix wrong dates in Power Automate with five examples covering local yesterday, UTC conversion, date-only values, daylight saving and daily report boundaries.

See the examples

Power Automate guide

Fix Power Automate Parse JSON errors: 5 worked examples

Fix Parse JSON errors with five examples covering objects, arrays, optional fields, nulls, numbers and IDs that start with zero.

See the examples

Power Automate / SharePoint / Get items

Power Automate Get items: filter queries and missing rows

Find the SharePoint rows you need with five examples. Try text, number and date filters, then check whether any records are missing.

See the examples

Power Automate / Arrays

Need one summary instead of one email per row?

Use Select and Join to make a readable summary. Check what happens when Get items returns zero, one or many results.

Read the array-to-string guide

Power Apps / Saving data

Patch says there is a network error?

Try a small update to check the connection, permissions, selected record and field types.

Troubleshoot Patch errors

Power Apps

Missing SharePoint records?

Check delegation, search by the start of a title and test records beyond the small sample loaded by the app.

Read the delegation guide

Power Automate

Which SharePoint edits should start work?

Choose which edits should start a flow, check which columns changed and plan for possible repeat runs.

Read the trigger guide

Power Automate

What happens when the report flow fails?

Group your flow steps in scopes, make failures easy to find and check what finished before you retry.

Read the error-handling guide

Excel / Reporting

Build a weekly report people can check

Try the free workbook with made-up data. Agree the report date, when work counts as overdue and how to show missing information.

Open the guide and Excel template

Power Apps / Planning

Excel, SharePoint or Dataverse?

Compare how each option handles shared updates, linked records, permissions and day-to-day use.

Compare the data sources

Workflow planning

Is this process ready to automate?

Decide what to automate, who owns it, what could go wrong and how you will check that it works.

Use the planning checklist
02 / Practical guide

What to expect from these guides

Need the full process? Follow the invoice intake and review workflow or approval and reminder workflow. Both include Power Automate setup and six worked examples.

Each technical guide links to Microsoft documentation, explains what its examples assume and gives you checks to run before changing a live workflow. The examples use made-up data. They are not client case studies or measured business results.

If you want help building or fixing something, bring the current process, an example of the problem and what a good result would look like. A workflow review helps you work through one process; Power Apps consulting covers an app project with agreed requirements.

Get help with your workflow

Need help with your team's version of this?

Tell me what you are trying to do, what is going wrong and who it affects. In a free 20-minute call, we can decide whether a workflow review or app project would help.

felipe@getquintera.com · These guides are free. We agree the work and cost of consulting separately.