Power Automate | New Blog

5 People who inspire me 2020

4 min

The Power Chatform Episode 5 - It’s still 2020

1 min

Check if records exist or don’t exist with Power Automate

2 min

{"items":["5fec7927e0826500175e4556","5fd0bea6c28aef0017443101","5fd0bea6c28aef0017443102"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"max","cubeRatio":1.7777777777777777,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":16,"galleryMargin":0,"scatter":0,"chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":0,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":3,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":0,"mobilePanorama":false,"placeGroupsLtr":false,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":["SHOW_ON_THE_RIGHT","SHOW_BELOW"],"galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":26,"textBoxWidth":200,"textBoxWidthPercent":65,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"gallerySizeType":"px","gallerySizePx":1000,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_15","value":"rgba(24,24,24,1)"},"showVideoPlayButton":true,"galleryLayout":2,"calculateTextBoxHeightMode":"MANUAL","targetItemSize":1000,"selectedLayout":"2|bottom|1|max|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":true,"externalInfoHeight":26,"externalInfoWidth":0.65},"container":{"width":300,"galleryWidth":316,"galleryHeight":0,"scrollBase":0,"height":null}}

Check if records exist or don’t exist with Power Automate

One of the most common scenarios for businesses is to check if a record exists and if it exists do something, if not, do something else. ...

Word Template in Power Automate - Introduction

Matt Collins-Jones

Sep 21, 2020

Word Template in Power Automate - Introduction

I love Word Templates. Not sure if that’s ever been apparent with all my posts on Word Templates or my presentations on them, but I do. I...

Update Multiselect Option sets by label values dynamically in Power Automate

Matt Collins-Jones

Jul 23, 2020

Update Multiselect Option sets by label values dynamically in Power Automate

Option sets are tricky fields to work with, both with Power Automate, reporting and 3rd party integration tools. I’ve done by fair share ...

Power Platform and D365 2020 Wave 2 Top picks and Patterns

Matt Collins-Jones

Jul 13, 2020

Power Platform and D365 2020 Wave 2 Top picks and Patterns

I love release notes. I’m not ashamed to say it, I get really excited at finding out what is in store for D365 and the Power Platform ove...

Create Records from Business Cards Power Automate

Matt Collins-Jones

May 25, 2020

Create Records from Business Cards Power Automate

In the digital era, it still strikes me as slightly odd that people still pass business cards. While LinkedIn and Twitter are my preferre...

Use Power Automate for currency conversions

Matt Collins-Jones

Mar 23, 2020

Use Power Automate for currency conversions

I blogged recently about embedding canvas apps into Model-driven apps and how this can now be easily done. As part of my Scottish Summit...

Call a Power Automate Flow from Custom button in CDS/D365

Matt Collins-Jones

Feb 17, 2020

Call a Power Automate Flow from Custom button in CDS/D365

Power Automate has a lot of advantages over Classic Workflows. I’ve given presentations on this topic and it’s an ongoing conversation pi...

Matt Collins-Jones

Dec 30, 2019

5 people who inspired me in 2019

As we move forward from 2019 into 2020, I wanted to write about the people that inspire me, the people who, when I see them do something,...

Calculate Age as Whole Number using Power Automate

Matt Collins-Jones

Dec 12, 2019

Calculate Age as Whole Number using Power Automate

This problem has annoyed me for a couple of years. I’ve used several methods over the years to calculate age in D365 from Business Rules,...

Matt Collins

Dec 2, 2019

#MSFlowVember Final Totals!!

What. A. Month! #MSFlowVember has come to an end and it’s been such a great reaction to it all. When I first came up with the idea for #M...

{"items":["5fd0bea6c28aef0017443102","5fd0bea6c28aef0017443104","5fd0bea6c28aef0017443105","5fd0bea6ba26020017d44e05","5fd0bea6ba26020017d44e00","5fd0bea6ba26020017d44e04","5fd0bea404dcd70017a406d5","5fd0bea404dcd70017a406cf","5fd0bea404dcd70017a406d4","5fd0bea404dcd70017a406d2"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"max","cubeRatio":1.7777777777777777,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":0,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":3,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":0,"mobilePanorama":false,"placeGroupsLtr":false,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_BELOW","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":271,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":0,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"gallerySizeType":"px","gallerySizePx":1000,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_15","value":"rgba(24,24,24,1)"},"showVideoPlayButton":true,"galleryLayout":2,"calculateTextBoxHeightMode":"MANUAL","textsVerticalPadding":-15,"targetItemSize":1000,"selectedLayout":"2|bottom|1|max|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":true,"externalInfoHeight":271,"externalInfoWidth":0},"container":{"width":612,"galleryWidth":644,"galleryHeight":0,"scrollBase":0,"height":null}}