I continually get frustrated because there are so many great blogs and tidbits of information out there that I want to keep up on, but there isn’t enough hours in the day. On social media I often see great blogs posted by colleagues and friends, or in my day to day while looking for solutions, I will come across other blogs on my own. The problem is that during the day I simply don’t have enough time to read all of them. So I simply leave my tabs open to come back later during lunch or a break. Except that never seems to happen as something always comes up. I usually have plenty of time to read them in the evening once everyone is settled down at home, but I always forget what I was looking at. I have tried emailing them home, but they get lost within all the other emails I received. I set rules, but even if I come back to them, I like to take notes and emails aren’t the best place to do that. So after reading Tracy Van Der Schyff’s blog on moving notes to Planner and Teams I had a thought. What about going the other way?
While planning out a new series I want to do around PowerApps and Flow I realized one of the things I needed to do was get the value of a lookup field into a text field. Now we all know that using a calculated field for this isn’t going to work since they can’t see lookup fields. Yes I could use a choice field instead, but in this case I wanted a lookup field so that the users could easily update the choices from the lookup list. There are a number of examples of doing this with a SharePoint Designer Workflow. So I got thinking, but about Flow? I found a number of examples of users asking for ways to do this or having problems doing it, but nothing really concrete. So I decided to write something up quick as it really is very easy to do with flow.