Skip to main content

Blog Archive

Every post on Dewiride Developer Blogs, newest first. Pick a year or a month to narrow it down, or page through them all.

Posts
1,085
Topics
132
Reading time
130 h
First post
Jun 2025

Posts 211–240 of 1,085 · November 8–9, 2026

Page 8 of 37

November 2026

802 posts

Monday, November 9, 2026

17 of 34 posts

  1. How to Convert UTC to Local Time in Power Automate with convertFromUtc

    SharePoint gives a flow its date and time columns in UTC. convertFromUtc() turns them into a time zone's local time and formats them in one step: convertFromUtc(time, 'GMT Standard Time', 'dddd dd/MM/yyyy') gave Saturday 07/11/2026.

  2. How to Get a User's Manager in Power Automate

    Find a person's manager in a cloud flow with the Office 365 Users action Get manager (V2): the person's email in User (UPN), then the manager's Mail and other details in the outputs. The example sends an approver's own overtime to their manager.

  3. How to Join an Array into Text in Power Automate

    Turn an array into one line of text with join() in Power Automate, with a separator between the items: join(body('...'), ';') makes a list of emails into the semicolon-separated form an approval's Assigned to field takes.

  4. How to Use Variables in Power Automate

    Hold a value that different branches of a flow set with Initialize variable and Set variable in Power Automate: initialize it at the top level, set it in each branch, and read it with variables(). The example sets who an approval goes to.

  5. How to Filter an Array in Power Automate

    Keep only the items of an array that match a condition with the Filter array data operation in Power Automate: From the array, then a condition on item(). The example removes the person who logged overtime from their department's approvers, with toLower() on both sides.

  6. How to Pick One Field from Each Item with Select in Power Automate

    Turn an array of objects into a plain list of one field with the Select data operation in Power Automate: From the array, Map in text mode with item()?['Email']. The example turns a SharePoint Person column with several people into their email addresses.

  7. How to Get a SharePoint List Item by ID in Power Automate

    Read one item from a SharePoint list in a cloud flow with Get item: the site, the list and the item's ID, often a number stored on another item. The example reads a department and its approvers, then reads an entry again later to see its latest values.

  8. How to Count the Items in an Array in Power Automate with length()

    Count how many items an array has with length() in Power Automate, and branch on it in a Condition: length(...) is greater than 0. Real runs of an approval flow with one approver and with none.

  9. How to Add a Trigger Condition in Power Automate

    Make a cloud flow start only when a condition is true with a trigger condition in the trigger's Settings: an expression that starts with @. The example runs a SharePoint flow only for items whose Status is Pending, so the flow's own updates don't start it again.

  10. How to Use Environment Variables in a Power Automate Flow

    Use a solution's environment variables in a cloud flow's trigger and actions instead of a fixed SharePoint site and list: Enter custom value, then pick the variable from dynamic content, where the new designer lists it under Parameters.

  11. How to Run a Flow When a SharePoint Item Is Created or Modified in Power Automate

    Start a cloud flow when an item is added to or changed in a SharePoint list with the trigger When an item is created or modified: the site and list, what the trigger gives the flow, how soon it runs, and one run per item.

  12. How to Create an Automated Cloud Flow in a Solution in Power Automate

    Create a cloud flow that runs by itself when something happens, inside a Power Platform solution: New, Automation, Cloud flow, Automated, a name and a trigger, the first action so it can be saved, and opening it in the new designer.

  13. Fixed: A Flow in a Solution Uses Another Solution's Connection Reference in Power Automate

    A new flow in a solution connected its SharePoint trigger and actions to a connection reference from another solution in the same environment, and its own solution had no connection reference. Creating one in the solution and switching each action to it fixed it.

  14. Fixed: "The provided workflow run action name has these invalid characters" (InvalidWorkflowRunActionName) in Power Automate

    Publishing a flow failed with InvalidWorkflowRunActionName: the action name 'Anyone_left_to_approve?' has these invalid characters '?'. Action names can't contain control characters or < > % & \ ? /. Renaming the conditions without a question mark fixed it.

  15. Fixed: "The input parameter(s) of operation contains invalid expression(s)" in Power Automate

    Publishing a flow failed with The input parameter(s) of operation 'Ask_the_manager' contains invalid expression(s). An apostrophe in the name of the action it read from, Get the employee's manager, broke the quoted name inside the expression.

  16. Fixed: "Should at least contain one trigger and one action" When Saving a Flow in Power Automate

    Saving a new automated flow that had only its SharePoint trigger showed Should at least contain one trigger and one action in Power Automate's classic designer. A flow needs an action before it can be saved; adding the first one fixed it.

  17. Fixed: "Site Verification is not completed" (403 SiteVerificationNotCompleted) in IndexNow

    The first time I sent this site's URLs to IndexNow, it answered 403 SiteVerificationNotCompleted, though the key file was live and correct. Bing hadn't checked the key yet. Here's how to tell it apart from a bad key, and the fix: wait a few minutes and send the same request again.

Sunday, November 8, 2026

13 of 55 posts

  1. Build an Overtime Timesheet App in Power Apps — Part 7: Build the My Overtime Screen

    Build the My Overtime screen: a month of each person's overtime with status badges, the month's total and Monday-to-Sunday weekly totals, previous and next month buttons, and editing an entry on the Log Overtime screen until it's approved.

  2. How to See What a Formula Returns in Power Apps Studio

    Select a formula in Power Apps Studio and a strip under the formula bar shows its result and its data type. How to read it for numbers, dates, text and Blank, how to check one part of a formula, and the formulas it can't work out. Live examples.

  3. How to Show Column Totals in a SharePoint List View

    Show a total under a column in a SharePoint list view: Totals in the column's menu, then Sum, Count, Average and more. In a grouped view each group gets its own total. Done live on an overtime list, with the classic Edit View setting too.

  4. How to Group Items in a SharePoint List View

    Group a SharePoint list's items under headings by a column's value: Group by from the column's menu, Save view as to keep it, and a second level of grouping from Edit current view. Done live on an overtime list, grouped by month and then by person.

  5. How to Stop Editing an Item Once It's Approved in Power Apps

    Let people change a request until it's approved, then lock it: hide the Edit button on approved rows of a Power Apps gallery with Visible, and send an edited rejected item back for approval. Live in a timesheet app, with what SharePoint itself does.

  6. How to Exclude the Item Being Edited from a LookUp in Power Apps

    A duplicate or overlap check finds the item you're editing. SharePoint can't run ID <> on its ID column, so let SharePoint find the matches, hold them in memory with With, and skip the edited item there. Before and after, live, with no delegation warning.

  7. How to Show That a Shift Ends the Next Day in Power Apps

    A night shift written as 22:00 to 06:00 looks like it ends before it starts. Add next day when the finish falls on a later day than the shift's date, with If and Day. Live result in Studio and in a timesheet app's gallery rows.

  8. How to Total Each Group in Power Apps with GroupBy and Sum

    Total each group of records in Power Apps: GroupBy the records, then AddColumns with Sum over each group's nested table. Weekly overtime totals, Monday to Sunday, worked out live in Studio and shown as one line per week on a timesheet screen.

  9. How to Group Records in Power Apps with GroupBy

    GroupBy turns a table into one row per value of a column, with the matching records in a nested table. Group a month's overtime entries by the week they fall in, count each week's entries, and see the result live in Studio. Plus the delegation rule for GroupBy.

  10. How to Add Up a Column in Power Apps with Sum

    Sum adds up a column of a table in Power Apps: Sum(Table, Column). Live results from Studio for a month's overtime hours, with and without a filter, and why a SharePoint list is summed after its rows are loaded into a variable.

  11. How to Filter a SharePoint List Between Two Dates in Power Apps

    Filter a SharePoint list to the items between two dates in Power Apps with >= and <= on a date column. SharePoint runs the query itself, with no delegation warning. Live results showing both end dates included, on a summer-time date too.

  12. How to Add Previous and Next Month Buttons in Power Apps

    Let people move a Power Apps screen a month at a time: keep the month in a context variable as its first day, move it with DateAdd from two icon buttons, show it as November 2026, and stop the next button at the current month. Built and tested live.

  13. How to Show the Day Name of a Date in Power Apps

    Show the day of the week as a name in Power Apps with Text: dddd gives Monday and ddd gives Mon, so ddd dd/mm/yyyy shows Mon 02/11/2026. Live results from Studio, and the date line of each row in a timesheet app's gallery.