Matthew Devaney
@mattbdevaney
Followers
10K
Following
5K
Media
1K
Statuses
11K
I write about #PowerApps ✍️ at https://t.co/p8vBW9L7j8 | Microsoft MVP | #PowerAppsTip(ster) | Definitely Not A Cat 😸
Winnipeg, MB, Canada
Joined August 2019
New #PowerApps Book 📕 I wrote a book with 50+ pages of coding rules, guidelines and best practices I use everyday to create #PowerApps Canvas apps 😀 Download the PDF version for FREE 👇 🔗
matthewdevaney.com
Welcome to the Power Apps Coding Standards For Canvas Apps. This guide has over 50 pages of coding rules, guidelines & best practices
16
78
223
New Blog Post 😃 In this #PowerAutomate article I share how to extract data from a web page using by a cloud flow 🤖 You don’t always need Power Automate desktop to do web scraping 🖥️ 🔗 https://t.co/bPkn8UZyjq
matthewdevaney.com
Power Automate cloud flows can be used to extract data from a web page by getting the HTML and output its details with an AI Prompt.
4
7
23
Yes, you can GET up to 999 emails in #PowerAutomate 📬 You've got to use #MSGraph to do it 😎 But fear not, its a standard flow action ⛔
1
3
40
New Blog Post 😀 In this #PowerAutomate article I show how to get more than the 25 email maximum from an inbox📬 We are going all the way to 999 emails 😎 🔗
matthewdevaney.com
To get over 25 emails in Power Automate use the Outlook - Send An HTTP request action instead of the Outlook - Get Emails (V3) action.
1
4
17
New Blog Post 😃 In this #PowerAutomate blog post I share how to host a webpage using a flow. 🛜 That’s right. A web page. Hosted. By a flow. 🔗 https://t.co/tkoTvx6G7Z
matthewdevaney.com
Power Automate can be used to display a web-page or even a single-page web application in a web browser by returning HTML code.
1
5
23
New Blog Post 😃 In this #PowerPlatform article I build a flow to force sync users and update the Dataverse Team members when new users are added to an Entra Security group. Notice the cat getting being forced to take a bath? 🔗 https://t.co/N32lTwv9qP
matthewdevaney.com
We can solve this using a flow to force sync users & update the Dataverse Team members when new users are added to Entra Security group.
2
5
15
I am going to coast for awhile on my unpublished drafts.
2
0
15
TIL there is a "Copy Set Name" feature in #Dataverse 😎 It is super helpful for #PowerAutomate when you are updating a Dataverse lookup and need to know the Entity Set Name. And the best part is that I wasn't the clever person who figured this out. It was my readers.
1
3
21
New Blog Post 😃 In this #PowerAutomate article I show how to update a lookup column in #Dataverse 👀 Everytime I have to do this I forget the lookup syntax so I wrote this article so I will never forget again 🐘 🔗
matthewdevaney.com
The Power Automate syntax to update a lookup column in Dataverse is difficult to memorize so I have written a quick-guide on how to do it.
0
5
12
I found links to the original #PowerApps & #PowerAutomate forums. 😎 Guess what? You can still read all of the old posts there. 🔥🔥 I'll share the links to these forums below 👇🏻 Power Apps Forums 🔗 https://t.co/CjW0FJJNHC Power Automate Forums 🔗 https://t.co/bj5b5jKN4e
3
6
43
Amazing Tip 🔥🔥🔥 Copy and paste the Fetch XML from #PowerApps into a List Rows action in #PowerAutomate to filter results without writing any code 😎
1
3
38
New Blog Post 😃 In this #PowerAutomate post I show how to get the rows from a #Dataverse view. I’ll also reveal how you can use saved queries so the view remains updated in Power Automate when there are changes 🔗 https://t.co/VCeg09r1Zb
matthewdevaney.com
Power Automate can be used to list the rows in a Dataverse view. Views filter a table by a set of criteria and show the selected columns.
0
4
9
New Blog Post 😃 In this #PowerAutomate article I share how to get over 5,000 items from a #SharePoint list. 📜 I’ll also reveal how to manually perform pagination so you can get the maximum number of records from any datasource 📈 🔗 https://t.co/CzyUTy6QXH
matthewdevaney.com
The Power Automate Send An HTTP Request To SharePoint action can return more than the limit of 5000 list items by using pagination.
1
8
31
New Blog Post 😃 In this #PowerAutomate I share how to connect to #ServiceNow and read/write data. I’ll also reveal how to authenticate using OAuth2 🔑 🔗 https://t.co/L3PMikbDL6
matthewdevaney.com
Power Automate can connect to ServiceNow to get records and perform other CRUD operations (create, read, update, delete).
0
7
17
#PowerApps Tip 💡 Wildcards (*) can be used to do a "contains" query (aka. search) in model-driven app columns. You are not limited to "begins with" queries 🔎
2
2
30
New Blog Post 😃 In this #PowerAutomate article I share how to write values to any cell or range in an Excel sheet ✍️ Absolutely anywhere. Just like you’ve always wanted to. https://t.co/SVKS6DD5ka
matthewdevaney.com
Power Automate can write a value a specific cell in Excel without that cell being included in a table or write values to range of cells.
1
5
8
I have a backlog of 7️⃣ completed #PowerApps and #PowerAutomate blog posts right now. If I consider Christmas (no blog post) and New Years (2024 roundup) that's 9️⃣ weeks of content I've already got. I'm considering what to do with this buffer time I've built. 🤔💭⏰
4
0
19