Convert Float to Integer in Power Automate – #PowerAutomateShorts
Welcome to one more #Shorts series for #PowerAutomate. In this video we will talk how we can convert Float to Integer in Power Automate. During the conversion we will convert Float to nearest Whole number.
Power Automate, Power Automate Tips and Tricks, Power Automate Functions Reference
Follow Dhruvin on Social Media:
Follow my other channel for short content: @Digital Dhruvin
Check if String is INT or Float – IsInt and IsFloat in Power Automate
In today’s short let’s talk about a quick way to check if the string is Integer or Float. In Power Automate we have two functions available – IsInt and IsFloat. This function will return true if the string is Integer or Float. Let’s talk about these things in detail.
Follow Dhruvin on Social Media:
Follow my other channel for short content: @Digital Dhruvin
Unstructured Document Processing with Power Automate and AI Builder
During this video, we will learn how we can automatically Process Unstructured documents using Power Automate and AI Builder. Microsoft now comes up with the capability of unstructured document Processing. Once our AI Builder Model is developed, trained and published we can consume AI Builder Document Processing Model in Power Automate.
Here I have taken a real-life example, where we are uploading the documents in SharePoint Document Library. Once documents are uploaded, it will automatically process those documents using Power Platform and Unstructured Document Processing Model and Populate the data in SharePoint List. So, Let’s explore AI Builder Unstructured Document Processing technique in detail.
Key Takeaways:
1. AI Builder Unstructured Document Processing with Power Automate
2. Power Automate Document structuring
3. Intelligent Document Processing (IDP) capabilities for Power Automate
4. Document Processing
5. Rental Document Processing with Power Automate
Chapters:
00:00 Start
00:56 Business Scenario – Rental Document Processing using AI Builder
01:50 Create Power Automate for Unstructured Document Processing
03:20 AI Builder Action in Power Automates
04:35 Add Extracted Fields from
06:07 Check Flow Run
06:25 Extracted Record
07:12 Subscribe!
Dhruvin’s Social Media:
Follow my other channel for short content: @Digital Dhruvin
Power BI Delhi UG & PH UG – July Meet Up – Field Parameters in Power BI
📻✨ Happy to announce Power BI PH Community & Delhi Power BI User Group’s Monthly Meet Up!
📆 July 30, 2022 Saturday
⏰10:30 AM IST | 01:00 PM SGT
𝐒𝐩𝐞𝐚𝐤𝐞𝐫: Rajendra Ongole
𝐒𝐞𝐬𝐬𝐢𝐨𝐧 𝐓𝐢𝐭𝐥𝐞: Field Parameters in Power BI
Collection in Power Apps
During this episode, we will learn about Collection in Power Apps. The collection is used to store same group of data. Collections store data temporarily. Here, we will see how we can store the values inside the collection. We will check where the collection can be used inside the Power Apps. We will also check procedure for creating collection. The collection holds the value temporary in the browser memory cache. We will explore CLEARCOLLECT function in detail. Also we will check When to use collect and when to use clearcollect function. So, stay tuned!!
Welcome to Power Apps step by step beginner tutorial series for Beginners. This is the complete beginner tutorial series for Power Apps Canvas Apps and Dataverse. The PowerApps series is fully focussed on beginners. Here, we will develop the complete Power Apps from scratch.
Are you new into PowerApps? Do you want to learn PowerApps from scratch? Do you need complete PowerApps beginner series free at your home? Do you need practical knowledge of Power Apps? Do you want to prepare yourself to develop Production based Power Apps by your own? Then you’re at right place!! This is the start of Power Apps Development!!
Key Takeaways:
Power Fx – SET
Power Fx – UpdateContex
When to Use set and when to use UpdateContext?
Set Vs UpdateContex
Chapters:
00:00 Start
00:46 Introduction to Collections
01:53 Store value in collection
03:54 Add Value in Collection
05:10 Display Collection Value
06:04 Clear Collection Data
06:44 CLEARCOLLLECT in PowerApps
07:18 Use-cases for Collection
08:12 Scope of the Collection
08:42 Bind Dropdown with Collection
11:56 Subscribe!
********
Useful Links:
Power Apps Beginner Tutorials Playlist:
Chapter 0:
PowerApps Tutorials for Beginners: Course Outline:
Chapter 1 :
Introduction to Power Apps – What & Why?
Chapter 2:
Overview of PowerApps Tooling
Chapter 3
Create Microsoft 365 Developer Account
Chapter 4
Overview of Environment and Solution in Power Apps
Chapter 5
Variables in Power Apps
Chapter 6
Collection in Power Apps
Chapter 7 to 22
COMING SOON..RECORDING IN PROGRESS
Version History in Dataverse for Table Records
Welcome to one more exciting tip and trick related to Dataverse.This video will teach us how to enable version history for Dataverse table records. We all know that SharePoint comes up with a default Version History. But how about Dataverse? In Dataverse, if we need version history then we need to turn on the Auditing feature from Admin Center. Once we enable the feature we can turn on Audit changes data in dataverse table. To check the Audit History we need to create one model-driven app. From that model-driven app, we can check the history of each record!
Key Takeaways:
Dataverse table Audit History
Dataverse table auditing
Version History for Dataverse table
Audit table in dataverse
Chapters:
00:00 Start
01:06 Open Admin Center
02:16 Enable Auditing from Dataverse Table
02:35 Audit changes to its data
02:50 Check Audit History
03:35 Create Model Driven App to view Audit History
04:39 Check Version History for Dataverse Table
Follow Dhruvin on Social Media:
Follow my other channel for short content: @Digital Dhruvin
Install On Premise Data Gateway for Power Apps
During this video, we will learn how we can install On-Premise Data Gateway to consume data from On-Premise Data Sources like file system, SQL Server and more. Gateway acts like a bridge between On-Premise Data source and Power Platform. Sometimes we want to connect On-Premise Data sources to our Power Automate flow and Power Apps. At that time we need On-Premise Data Gateway. During this session we will learn to install data gateway for PowerApps and Power Automate.
Chapters:
00:00 Start
00:30 Open Gateway in Power Apps
01:00 Prerequisites to Install Gateway
02:03 Download Standard Gateway for Power Apps
02:57 Install Data Gateway
03:40 Configure M365 Account with Data Gateway
04:20 Enter Gateway Name & Recovery Key
05:00 See Gateway in Power Platform
05:15 Subscribe!
Trigger Power Automate only When SharePoint List Item Modified
Welcome to one more Tip for Power Automate and SharePoint. Most of the time we are triggering our Power Automate flow “When Item is created or Modified”. Sometimes we have a scenario where we need to trigger our Power Automate flow only when an Item is modified or updated. During today’s video, we will talk about one short trick using which we can trigger our Power Automate flow during Update! Let’s see!
We will use “When An Item Or File Is Modified Trigger For SharePoint Connector” for this solution. So, Let’s get started!
Follow Dhruvin on Social Media:
Follow my other channel for short content: @Digital Dhruvin
How to create Power Apps using Excel ?
In this video, we will learn how we can create Power Apps using Excel files. Excel is used to store data in form of rows and columns. We can create Power Apps using Excel as a data source by uploading the Excel to the OneDrive for Business. When we use Excel with Power Apps, there are many limitations as well. In this video, I will explain, why to avoid Excel to build Power Apps? Also, I will talk about alternatives to Excel to use with Power Apps. So, stay tuned till the end.
Key takeaways:
1. Use Excel with Power Apps
2. Excel and Power Apps
3. Limitations of Excel with Power Apps
4. Alternatives of Excel as Datasource
5. Migrate Excel data to SharePoint and create Power Apps
6. Migrate Excel data to Dataverse and create Power Apps
7. Connect Excel and Power Apps
Chapters:
00:00 Start
O2:13 Get Started with Excel and Power Apps
02:50 Open OneDrive and Upload Excel File
05:10 Create Power Apps from Scratch
05:20 Create ODFB Connection for Power Apps
07:31 Newly created column in Excel – PowerAppsID in Excel
08:30 Change Position of Element in Power Apps Forms
10:06 Change Theme for Power Apps
10:45 Limitations of Excel with Power Apps
11:00 Limit of 2000 Records for Excel and Power Apps
11:33 File Lock Error for already Open File
12:47 No Row Level Security with Excel and Power Apps
14:06 Alternative of Excel with Power Apps – SharePoint
15:03 SharePoint as a Datasource instead of Excel
17:42 Upload Excel and create SharePoint List
19:15 Create Power Apps form SharePoint List
20:04 Overview of created Power Apps
21:23 Dataverse Approach
21:55 Upload Excel Data to Dataverse Table
22:35 Remove Unused Files
****************
Dhruvin’s Social Media:
Follow my other channel for short content: @Digital Dhruvin