Microsoft 365 – Annabel Treshansky's Blog

A row of white doors with one yellow door

Reading Time: 3 minutes

Recently I’ve been working on a Power App for academic and teaching office staff to organise feedback on postgraduate dissertations. Microsoft recommend a maximum of 30 connectors per Power App, so I decided to pass the course codes to Power Automate, where a Switch action could be used to choose which course’s SharePoint lists to read data from.

This is how I had set that up in Power Automate:

The Switch statement compares the course code passed in from Power Apps with text strings providing the code for each course. It should match one of them and then follow that course of action. But it didn’t. The two seemingly identical strings didn’t match, and the flow ran into the default (matching none) condition instead.

Two road signs pointing to the same location in opposite directions

Confusing road sign at Elan Village
cc-by-sa/2.0 – © Chris Henley – geograph.org.uk/p/265977

Mar 13, 2024

Painted artwork showing pictures in a spiral formation on a turquoise background

Using a Toggle to make a While Loop in Power Apps

By Annabel Treshansky

On 5th March 2024

In Power Apps, Programming, Useful Tips, Why, God, Why??

Reading Time: 3 minutes

Picture: One Infinite Loop, Ignacio Sanz, CC BY-SA 2.0, via Wikimedia Commons and Flickr

The Problem: Power Apps only has `ForAll` Loops

When I was creating a demo Power App to fetch and display Dad Jokes, one of the challenges I faced was to fit the joke text inside a speech bubble graphic. The speech bubble was expandable, but only within limits, so I needed to keep fetching jokes and checking the length of their text until I found one short enough to fit inside the bubble design.

Power apps editor screenshot with the text 'Too long'

After clicking the button: the app enters the loop and the text changes to ‘Too long’

However, looping in Power Apps turned out to be tricky. Unbelievably, I discovered there is only one kind of loop in Power Apps: ForAll, which is used for looping over tables and collections. Power Apps really doesn’t have any other kind of loops, or even GoTos in the coding it makes available.

Making a While Loop in Power Apps

However, after much research, trial and error, I found a way to do this with just the loop (More Dad jokes) button and a hidden toggle:

Mar 5, 2024

Making an OAuth2 Custom Connector to fetch data from the Stack Exchange REST API in Power Apps

By Annabel Treshansky

On 31st May 2022

In Power Apps

Reading Time: 26 minutes

Introduction

This post describes a Power App that fetches and displays data from the Stack Exchange REST API using OAuth2 authentication, with a custom connector created by importing a collection from Postman.

Why did this happen?

This is a step in my ongoing project to access our Blackboard Learn Virtual Learning Environment using REST APIs. I thought this might be possible using Microsoft Power Apps, which would allow the development of apps more quickly, but getting the connection itself figured out was proving complex^{(*here’s why)}.

The first step in testing out this theory was my Dad Jokes Power App, which did not require any authentication.

Once that worked, the next step was to try the same process with another REST API that used the same kind of OAuth2 authentication process as Learn. After searching through various free public API lists, I found the Stack Exchange API, which seemed to match the authentication process fairly closely, and has good instructions too.

I also thought it looked useful in its own right, both for keeping up with news from developers, and for trying out methods for searching, sorting and filtering data when I got further into the Power Apps side of app development.

May 31, 2022

Using JSON formatting in SharePoint columns to display fields from a Person data column

By Annabel Treshansky

On 28th March 2022

In SharePoint, Why, God, Why??

Reading Time: 10 minutes

The Problem: How could I access data fields from a SharePoint Person column to display in another column?

I’ve been developing a laptop booking system in SharePoint and PowerApps.
As part of the Bookings list, I need to display data columns for the borrower’s name, user id and email address. This data is all included within SharePoint’s ‘Person or Group’ data type, however, I can’t access the Person data fields using lookup or calculated columns.

Mar 28, 2022

Screenshot of a Power App that fetches random jokes from a REST API

Making a Dad Jokes App using REST APIs and Power Apps Custom Connectors

By Annabel Treshansky

On 10th March 2022

In Power Apps, Programming, Why, God, Why??

Reading Time: 30 minutes

This post describes a Power App that fetches and displays data from a simple REST API using a custom connector created by importing from Postman. The app also uses a Toggle control to create a While loop in Power Apps.

The app itself can be found here: https://apps.powerapps.com/play/f1478489-b888-4e8a-9fe5-8c244e126e70?tenantId=2e9f06b0-1669-4589-8789-10a06934dc61, but is sadly only available to those with a University of Edinburgh login, as this app is a personal educational project and is not for publication or profit.

Why did this happen?

I’ve recently been working on a project to access our Blackboard Learn Virtual Learning Environment more efficiently using REST APIs. It occurred to me that this might be possible using Microsoft Power Apps, which could allow the development of apps more quickly, if we could get the connection itself figured out. The Dad Jokes app was developed as a proof (or otherwise) of the concept.

Mar 10, 2022

Screenshot: Adding a new list item in Teams

Copying Files, Flows, a Plan, SharePoint Lists and a Notebook from one Microsoft Team to another

By Annabel Treshansky

On 31st March 2021

In Flow / PowerAutomate, Office 365, Organisation, SharePoint, Teams, Useful Tips, Why, God, Why??

Reading Time: 13 minutes

First thing on the list: get organised!

A couple of weeks ago I discovered a University document called the New Learning Technologist Development Toolkit. And so I began a new project to follow it and develop my skills in Learning Technology. Obviously a project like this needed some way over the top organising… 😁

A while ago, I developed my own Microsoft Team called ‘Team of Me’, for organising myself and bringing my notes and notifications together in lockdown. This seemed like a good place to organise my training plans, so at first I created a channel in this Team to collect resources for this new project.

I began setting up a plan in Planner, creating lists of links, collecting PDF resources, making a few notes in the OneNote notebook and setting up some helpful Flows to channel messages into the right places, and cheer my progress along.

However, I soon discovered that the New Learning Technologist Toolkit, which looked like a short PDF, was actually a lot bigger than I’d thought. Everything it mentioned sent me down another rabbit hole of links and documents, and I realised it would need several channels in its own right to organise it all.

In fact, I began to suspect that becoming a Learning Technologist would take a lot longer than the 4 weeks listed after all. Who knew🙄. And so I decided to set my project up in a new Team of its own, which I’ve called ‘My New Learning Technologist Toolkit Team’.

The challenge now was to copy across the content I had collected and created in my original Teams channel into this new team.

Mar 31, 2021

Day 1 of Microsoft 365 Global Developers’ Bootcamp: Getting Set Up with Teams, SharePoint and other Microsoft Accounts

By Annabel Treshansky

On 6th November 2020

In Flow / PowerAutomate, Microsoft 365, Office 365, Organisation, SharePoint, Teams

Reading Time: 5 minutes

Recently I had the great opportunity of attending the Microsoft 365 Global Developers’ Bootcamp. This consisted of two workshops, each going through a series of activities around a themed task, developing applications for use with Microsoft Teams, and using the Microsoft Graph API.

The workshop for Day 1 was ‘Build an Emergency Response Solution with Teams and SharePoint’.

This workshop was run by Bob German, and it took us through a series of tasks to create a Teams app for coordinating the response to an emergency such as a natural disaster. It grew out of work done to help with the aftermath of the 2004 Boxing Day Tsunami in Asia.

Nov 6, 2020

Day 2 of Microsoft 365 Global Developers’ Bootcamp: Building One Productivity Hub

By Annabel Treshansky

On 4th November 2020

In Office 365, Programming, SharePoint, Teams

Reading Time: < 1 minutes

Obviously this was one of the high points for me: there I am in second place on the podium in the Kahoot quiz!

To be fair, I did do this quiz twice…

Personally I would love to have my own working copy of the One Productivity Hub app, as it is a step better than the ‘Team of Me’ that I had put together earlier in lockdown as an attempt to bring all my notifications together. I am still a step or two short of being able to install something like that in our Office365 setup: our security does not allow for setting up the ‘ngrok’ tunnelling and I don’t know yet how to deploy the app in a more permanent way.

So at the moment I am stuck on this error when I try to install it to my personal Team:
Valid domains cannot contain a tunneling site. Please remove these in your manifest. To help to ensure the security of your app and users, domains outside of your organization's control (including wildcards) and tunneling services cannot be included in the valid domains in your manifest.

But it’s been a great learning experience, so I thought I’d share my joy and thank the instructors on Twitter😎:

Really interesting couple of days making Microsoft Teams apps at #m365bootcamp Thanks, @aycabs and @Bob1German! pic.twitter.com/Lnd6IH36LL

— Annabel Treshansky (@ATreshansky) October 14, 2020

Links

One Productivity Hub Teams App

Nov 4, 2020

Using Flow with Teams, part 2

By Annabel Treshansky

On 3rd April 2020

In Collaborative Software, Flow / PowerAutomate, SharePoint, Teams

Reading Time: 19 minutes

Recap

This is a follow on from my previous post, ‘Using Microsoft Flow to update a Teams group with SharePoint activity‘. Flow is also known as Power Automate, and it is a Microsoft method for connecting apps so that outputs from one app can become inputs to another app, and events that happen in one app can trigger procedures in another app.

In my previous post, I added Flow to a Microsoft Teams group, and set up conditional testing to post a message in one of two Teams channels, depending on the value chosen in a metadata column when a file was uploaded to a SharePoint library belonging to the Team.

The Plan

The next steps to improve on this Flow will be:

Changing the SharePoint column name to ‘Relevance’ and the option labels, Teams channel names and Flow conditions to say ‘Urgent’ and ‘FYI’ rather than ‘Yesterday’ and ‘Never’. This morphed into the far more complicated problem of waiting for the SharePoint column value to change before continuing the Flow.
Jump to this section.
In the message that’s posted to Teams, change the text displaying the uploaded file’s URL to a working link to the file.
Jump to this section.
Post the message in Teams using the name of the person who uploaded the file to SharePoint.
Jump to this section.
Another thing I would like to do is to add the updates as cards in ‘To Do’ columns in the Teams group Trello board.
Jump to this section.
Summary: Bringing the last few things together. Jump to summary section
Jump to links

Apr 3, 2020

Using Microsoft Flow to update a Teams group with SharePoint activity

By Annabel Treshansky

On 29th March 2020

In Flow / PowerAutomate, SharePoint, Teams, Useful Tips

Reading Time: 6 minutes

I resumed my progress with Microsoft Flow after a pointless side quest attempting to change my favicon in SharePoint. I had very little success there, though I learned a lot, but with this, thankfully, I am having better luck.

To get started, I watched some of a video course on LinkedIn Learning: Microsoft Power Automate: Beyond the Basics, with Gini von Courter. I’ve watched enough of these now that I find Gini quite calming and pleasant to listen to: it’s a no nonsense way to get back in the frame of mind for the Microsoft universe (which is like the Marvel universe, but kind of solid, unmoving and heavy).

As it turned out, this course was ideal for me, because I’d already set up a Teams group for my current project and Gini started off with adding Microsoft Flow to Teams. Being quite new to Microsoft Teams, I hadn’t thought of doing that before, but it does make a lot of sense and offers some useful opportunities worth practising.

Mar 29, 2020

...in which I don't go up mountains

Category: Microsoft 365 Page 1 of 2

Fixing two identical strings that don’t match in Power Automate

Using a Toggle to make a While Loop in Power Apps