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 postsMonday, November 9, 2026
17 of 34 posts
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.
6 min readHow 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.
5 min readHow 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 min readHow 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 min readHow 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 min readHow 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.
5 min readHow 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.
5 min readHow 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.
5 min readHow 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.
6 min readHow 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.
6 min readHow 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.
7 min readHow 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.
7 min readFixed: 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.
6 min readFixed: "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.
5 min readFixed: "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.
7 min readFixed: "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.
5 min readFixed: "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.
11 min read
Sunday, November 8, 2026
13 of 55 posts
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.
42 min readHow 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.
8 min readHow 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.
6 min readHow 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.
6 min readHow 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.
5 min readHow 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.
6 min readHow 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.
4 min readHow 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.
5 min readHow 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.
5 min readHow 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.
6 min readHow 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.
6 min readHow 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.
6 min readHow 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.
4 min read