Explore the intriguing quest of transferring files between tables with Power Automate, as Megan V. Walker delves into a problem that seems straightforward but is fraught with unexpected challenges. Discover a layered approach to solutions, from no-code to high-code methods, and follow the journey that even experienced pros like Chris Piasecki and Guido Pietre weigh in on. It’s a story of integration, automation, and the ever-surprising twists in the world of data management.
Tip #1434: Can you count OR how to add index to array in Power Automate
When developers like Mike! start their sentence with “this is probably really simple”, you know that it rarely is. (No idea why he’s so excited about his name though, I suspect there is some math flex in here). This is probably really simple, but anyone know how I would add an index to an array […]
Tip #1432: Create records in Power Automate without mandatory fields
I really like mini truck stops when two or more MVPs brainstorm a random problem, usually because they are bored 😈. Help me understand scenarios where one would use a guid() expression in flow when creating new rows. Antti Pajunen What Antti left out was (reasonably) common wisdom that explicitly setting identifiers for new records […]
Tip #1426: Power Automate Gymnastics Reference Guide
Power Platform Tip of The Day presents: Power Automate expressions you didn’t know you needed until you found them. Everyone keeps a stash of useful Power Automate expressions in Notepad++, VS Code, EMacs, vi, or sticky notes if you don’t know what any of the above mean. Good citizens and developers (Amey “ABC” Holden, Antti […]
Tip #1379: App People vs. Flow People
The wand picks the wizard Nick Doelman Too tired to read? Why wouldn’t you listen instead – t.j. It’s been my observation that with a few notable exceptions, people in the Power Platform community primarily focus on Power Apps or on Power Automate. Lots of people will use both, but generally people are more “app […]
Tip #1339: The easiest CDS/Dynamics 365/CRM connection ever
Question I need to write a small console app that can authenticate to an online CRM instance with multi-factor authentication turned on. Can anyone point me in the right direction on how to accomplish this? Stephen Smith We’ve been through the topic of connections a few times before but this conversation is just too good […]
Tip #1302: Should I recreate the account entity?
When deploying Dynamics 365, there are frequently multiple types of companies and organizations that you will be tracking in the system. Some represent customer/client organizations, some may be support and advisory organizations like accountants and legal firms, and some may be miscellaneous types of organizations, such as trade associations. How should you manage multiple categories […]
Tip #1251: Run workflow when something did not happen
Flow is all the rage these days but there are some scenarios where classic workflow still rules. Classic workflow has the uncanny ability to readjust itself when underlying data you’re waiting for, changes. This dialog took place not so long ago: Steve “Reads his own blog” Mordue: I want to trigger a workflow to update […]
Tip #1211: Mixing entities to build complex views
The trick to get developers to get your job done for free is to challenge them. Which is exactly what Steve “Mr SMB” Mordue has done. Challenge I am trying to create a view of activities, that will show all activities performed by anyone on my team. I know I can create specific view that […]
Tip #1155: The Clock is Ticking on Your Endpoint
This is very much a collaborative post. Leon had a first go at it, George threatened to rip it all apart if posted because of the tiny technical inconsistencies. The verbal abuse discussion ensued, links were cross-checked, and now we have this. We have known for a while that the Dynamics CRM 2011 endpoint is […]