📚 Common Resources & URLs
| Tool/Resource | URL |
| Power Platform Admin Center | https://admin.powerplatform.microsoft.com |
| Microsoft Learn – Power Platform | https://learn.microsoft.com/power-platform |
| Dynamics 365 Docs | https://learn.microsoft.com/dynamics365 |
| Dataverse Table Reference | https://learn.microsoft.com/power-apps/maker/data-platform/reference |
| Power Automate Docs | https://learn.microsoft.com/power-automate |
| Power FX Reference | https://learn.microsoft.com/power-platform/power-fx/reference |
| Power CAT Samples | https://github.com/microsoft/PowerCATCodeSamples |
⚙️ Power Automate – Key Actions
| Action Type | Common Use | Example Expression |
| Get label as text from a lookup | If you get a contact record – it’s a lookup and you want the display name | Outputs(‘Get_contact’)?[‘body/_parentcustomerid_value@OData.Community.Display.V1.FormattedValue’] |
| Get first row from list rows Dataverse | You want the first record from a list rows which is a collection | first(outputs(‘List_rows’)?[‘body/value’])?[’emailaddress1′] |
| Get Row (Dataverse) | Fetch record by ID | Get row by ID from ‘Contacts’ |
| Update Row | Modify field in a table | Update ‘status’ field |
| Condition | Logic branching | @equals(triggerBody()?[‘field’], ‘value’) |
| Apply to Each | Loop through records | Use ‘value’ from list rows |
| Compose | Store/intermediate values | @concat() or @formatDateTime() |
| Scope | Group steps | Group related actions (e.g., Try/Catch) |
| Terminate | Stop flow with status | Success/Failure |
| Parse JSON | Use dynamic data | Use sample payload to generate schema |
🌐 Dataverse Web API Resources
| Resource | URL |
| Get a contact via web API | [Organization URI]/api/data/v9.2/contacts(contactid) |
| Open a view of a table even if the table isn’t in the app | [yourorganization].crm11.dynamics.com/main.aspx?forceUCI=1&pagetype=entitylist&etn=cm_outdooractivity |
| Get e.g. account and show specific columns | [Organization URI]/api/data/v9.2/accounts?$select=name,revenue,_primarycontactid_value,customertypecode,modifiedon |
| OData query using alternate key to return record Id cm_sql is alternate key and cm_outdooractivityid is record Id | https://yourorg.crm11.dynamics.com/api/data/v9.2/cm_outdooractivities(cm_sqlid=1)?$select=cm_outdooractivityid |
| API Reference | https://learn.microsoft.com/power-apps/developer/data-platform/webapi/overview |
| Web API Query Functions | https://learn.microsoft.com/power-apps/developer/data-platform/webapi/query-data-web-api |
| Authentication | https://learn.microsoft.com/power-apps/developer/data-platform/webapi/authenticate-oauth |
| Web API Types & Entities | https://learn.microsoft.com/power-apps/developer/data-platform/webapi/define-entity |
| Use Postman with Dataverse | https://learn.microsoft.com/power-apps/developer/data-platform/webapi/postman |
| | |
| Batch Operations | https://learn.microsoft.com/power-apps/developer/data-platform/webapi/execute-batch-operations |
🌐 Dataverse Resources
| Resource | |
| Record status – display name and schema/logical name Status / statecode Status /statusreason | |
Power Automate Array methods
Select: add index to array
| From | range(0,length(body('Select'))) |
| Map | addProperty(body('Select')[item()],'index',item()) 0 |
Select: use properties from array to make new array
| From | outputs(…) |
| Map | |
| Arg1 | item()?['cm_arg1'] |
| Arg2 | item()?['cm_arg2'] |
