Software training Videos And Materials
We provide Seo,wordpress,digital marketing,pythan,go programming,c,c++,Php with Project,php laravel With project many More courses .
Translate
Wednesday, 30 April 2025
MuleSoft Demo in Telugu by Mahesh Reddy Batch 09 30 April 2025 8AM
Monday, 28 April 2025
What is MuleSoft in Telugu || MuleSoft Training Course Overview By Venka...
Tuesday, 15 April 2025
Integer and Float Variables in Power Automate: Explanation with Examples
🚀 Integer and Float Variables in Power Automate: Explanation with Examples
In Power Automate, integer
and float
variables are used to store numerical values. Here's a breakdown of their usage, along with practical flow examples:
1️⃣ Integer Variables
- Purpose: Store whole numbers (e.g., 0, 15, -3).
- Common Actions: Initialize, increment, decrement.
- Example Flow: Counting Email Attachments
- Scenario: Count the number of attachments in an email.
- 🔔 Trigger: "When a new email arrives" (Office 365 Outlook).
- 🧰 Initialize Integer Variable:
- Name:
attachmentCount
- Type: Integer
- Value: 0
- Name:
- 🔄 Loop Through Attachments:
Apply to Each
(attachments):- 🔢 Increment Variable:
- Name:
attachmentCount
- Value: 1
- Name:
- 🔢 Increment Variable:
- 📧 Send Result:
-
Send Email
:Body: "Total attachments: @{variables('attachmentCount')}"
-
2️⃣ Float Variables
- Purpose: Store decimal numbers (e.g., 3.14, -5.67).
- Common Actions: Initialize, update via expressions.
- Example Flow: Calculating Total Order Cost
-
Scenario: Sum the prices of items in a SharePoint list.
-
🔔 Trigger: "When an item is created" (SharePoint list with items containing a
Price
column). -
🧰 Initialize Float Variable:
- Name:
totalCost
- Type: Float
- Value: 0.0
- Name:
-
🔄 Loop Through Items:
Apply to Each
(items):- 💰 Set Variable:
-
Name:
totalCost
-
Value:
@add(variables('totalCost'), float(item()?['Price']))
-
- 💰 Set Variable:
-
📊 Format and Log Result:
-
Update SharePoint
:Total: @{formatNumber(variables('totalCost'), 'C2')}
-
-
⚖️ Key Differences & Best Practices
- Aspect | Integer Variables | Float Variables
- 🧰 Initialization |
Initialize variable
→ Type: Integer |Initialize variable
→ Type: Float - 🛠️ Modification |
Increment variable
action |Set variable
withadd()
,sub()
, etc. - 📂 Use Cases | Counting, indexing, loops | Financial calculations, measurements
- 🧰 Common Functions |
add()
,sub()
,mul()
,div()
|round()
,formatNumber()
,float()
- 🧰 Initialization |
➕ Advanced Example: Dynamic Discount Calculation
-
Scenario: Apply tiered discounts to an order total.
-
🔔 Trigger: "When a new item is added" (SharePoint list with
OrderTotal
). -
🧰 Initialize Variables:
OrderTotal
(float):@\{triggerBody()?['OrderTotal']}
DiscountRate
(float): 0.0
-
🤔 Conditional Discounts:
-
If
OrderTotal
>= 1000:@setVariable('DiscountRate', 0.15)
-
Else If
OrderTotal
>= 500:@setVariable('DiscountRate', 0.10)
-
-
💰 Calculate Final Price:
-
Set Variable
:@mul(variables('OrderTotal'), sub(1, variables('DiscountRate')))
-
-
📧 Send Approval:
-
Teams Message
:"Final Price: @{formatNumber(variables('FinalPrice'), 'C2')}"
-
⚠️ Common Pitfalls & Solutions
-
Type Mismatch: Use
int()
orfloat()
to convert strings/numbers.@float(triggerBody()?['PriceString'])
-
Precision Issues: Use
round()
to limit decimal places.@round(variables('totalCost'), 2)
-
Incrementing Floats: Manually update using
add()
.@add(variables('totalCost'), 2.5)
✅ Conclusion
- 🔢
Integers
are ideal for counting and discrete values. - ⚖️
Floats
handle precise calculations involving decimals. - Use
Initialize variable
,Set variable
, and arithmetic functions (add()
,mul()
) to manage numerical logic effectively.
🏆 By leveraging these variables, you can build dynamic flows for inventory tracking, financial reporting, and more! 🚀
Variable Cascading in power automate with example
🚀 Variable Cascading in Power Automate with Example
- Variable cascading in Power Automate refers to the sequential use of variables where each subsequent variable's value depends on the previous one.
- This approach allows you to break down complex workflows into manageable steps, enhancing readability and maintainability.
- Below is a practical example demonstrating this concept:
💰 Example: Order Processing Workflow
- Scenario: Automate order processing by validating customer eligibility, calculating discounts, and generating a final invoice. Each step uses variables that depend on prior results.
🪜 Step 1: Trigger and Initialize Variables
* 🔔 **Trigger:** "When a new item is added" to a SharePoint list (e.g., *Orders* list).
* 🧰 **Initialize Variables:**
* 🆔 CustomerID: Store the customer ID from the trigger.
```
Name: CustomerID
Type: String
Value: @{triggerBody()?['CustomerID']}
```
* 💵 OrderTotal: Capture the raw order total.
```
Name: OrderTotal
Type: Float
Value: @{triggerBody()?['Amount']}
```
🪜 Step 2: Fetch Customer Details
* 🧑🤝🧑 Get Customer Tier:
* Use "Get item" (SharePoint) to fetch the customer’s membership tier using *CustomerID*.
* 🗄️ Store the result in a variable:
```
Name: CustomerTier
Type: String
Value: @{outputs('Get_Customer_Details')?['body/Tier']}
```
🪜 Step 3: Calculate Discount Based on Tier
* 💸 Set Discount Rate:
* Use a Condition to determine the discount:
```
If CustomerTier = "Gold", set DiscountRate = 0.15
Else if CustomerTier = "Silver", set DiscountRate = 0.10
Else, set DiscountRate = 0.05
```
* 💰 Initialize Variable:
```
Name: DiscountRate
Type: Float
Value: @{body('Condition')}
```
🪜 Step 4: Compute Final Amount
* 🧾 Calculate Final Total:
* Set Variable:
```
Name: FinalAmount
Type: Float
Value: @{mul(variables('OrderTotal'), sub(1, variables('DiscountRate'))}
```
🪜 Step 5: Generate Invoice
* 📄 Create Invoice:
* Use "Create file" (OneDrive) to save the invoice with dynamic content:
```
File Name: Invoice_@{variables('CustomerID')}.txt
Content:
"Customer: @{variables('CustomerID')}
Order Total: $@{variables('OrderTotal')}
Discount: @{mul(variables('DiscountRate'), 100)}%
Final Amount: $@{variables('FinalAmount')}"
```
🔑 Key Points
* **Cascading Dependencies:**
* CustomerID → Used to fetch CustomerTier.
* CustomerTier → Determines DiscountRate.
* DiscountRate + OrderTotal → Compute FinalAmount.
* **Benefits:**
* 🧩 Modularity: Each step is isolated and reusable.
* ✅ Clarity: Variables make the flow self-documenting.
* 🔧 Flexibility: Easily update discount rates or logic without disrupting the entire flow.
🔄 Advanced Use Case: Multi-Level Approvals
* **Scenario:** Escalate approval requests based on dynamic thresholds.
* **Initialize Variables:** ApprovalLevel = 1, MaxApprovalLevel = 3.
* **Loop:** While ApprovalLevel <= MaxApprovalLevel:
* Send approval to the corresponding team.
* If rejected, increment ApprovalLevel.
* If approved, exit loop.
✨ Best Practices
* 🏷️ Descriptive Names: Use clear variable names (e.g., DiscountRate, not var1).
* 🧱 Scope Management: Use Scope actions to group related variables.
* 🚨 Error Handling: Add checks for null/empty variables.
🏆 By cascading variables, you create 🚀 dynamic, adaptable workflows that mirror real-world business logic. This method is particularly useful for financial calculations, approval chains, and data transformations. 🚀
Saturday, 12 April 2025
practical use case example of variables in Power Automate
🚀 Variables in Power Automate: Support Ticket Escalation
Here’s a practical use case example of variables in Power Automate, demonstrating how they solve a real-world business problem and streamline automation:
📞 Scenario: Escalating Support Tickets Based on Priority
- Problem: A company’s IT team wants to automate support ticket escalations. High-priority tickets must:
- 🧑🤝🧑 Be assigned to Level 1 support.
- ⏰ Escalate to Level 2 if unresolved after 2 hours.
- 📢 Notify the manager if unresolved after 4 hours.
- Variables Used:
- 🔢 Escalation Level (integer)
- 📅 Ticket Created Time (string / timestamp)
- ✅/❌ IsResolved (boolean)
- 📧 Support Team Emails (array)
🪜 Step-by-Step Flow with Variables
1️⃣ Trigger
* "When a new item is created" (SharePoint list for support tickets).
* Capture ticket details:
```
Priority: High
Description: Server downtime
Created Time: 2023-10-05T14:30:00Z
```
2️⃣ Initialize Variables
* 🔢 Escalation Level: Track escalation progress.
```
Name: escalationLevel
Type: Integer
Value: 1
```
* 📅 Ticket Created Time: Store the ticket’s creation timestamp.
```
Name: ticketTime
Type: String
Value: @{triggerBody()?['Created']}
```
* 📧 Support Team Emails: Define teams to notify.
```
Name: supportEmails
Type: Array
Value: ["level1@company.com", "level2@company.com", "manager@company.com"]
```
3️⃣ Assign to Level 1 Support
* 📧 Send Email:
```
To: @{variables('supportEmails')[0]}
Subject: "New High-Priority Ticket: @{triggerBody()?['Title']}"
Body: "Please resolve within 2 hours. Ticket details: @{triggerBody()?['Description']}"
```
4️⃣ Check Resolution Status After 2 Hours
* ⏱️ Delay: Wait 2 hours.
```
Duration: PT2H
```
* 🤔 Condition:
```
IsResolved = @{equals(triggerBody()?['Status'], 'Resolved')}
```
* ❌ No (Unresolved):
* 🔢 Set Variable:
```
Name: escalationLevel
Value: @{add(variables('escalationLevel'), 1)}
```
* 📧 Send Email to Level 2:
```
To: @{variables('supportEmails')[1]}
Subject: "Escalated Ticket: @{triggerBody()?['Title']}"
```
5️⃣ Escalate to Manager After 4 Hours
* ⏱️ Delay: Wait an additional 2 hours (total 4 hours).
* 🤔 Condition:
```
IsResolved = @{equals(triggerBody()?['Status'], 'Resolved')}
```
* ❌ No (Unresolved):
* 🔢 Set Variable:
```
Name: escalationLevel
Value: 3
```
* 💬 Post to Teams:
```
Channel: IT-Managers
Message: "@{variables('supportEmails')[2]}, urgent ticket unresolved for 4+ hours!"
```
⚙️ Variables in Action
- 🔢 Escalation Level: Dynamically tracks the escalation stage (1 → 2 → 3).
- 📅 Ticket Created Time: Ensures accurate delay calculations.
- 📧 Support Team Emails: Centralizes team contacts for easy updates.
✨ Why Variables Matter Here
- 🔄 Dynamic Logic: Escalation level changes based on real-time conditions.
- ♻️ Reusability: Update
supportEmails
once instead of hardcoding in 3+ actions. - 🛡️ Error Resilience: Track progress even if the flow fails midway.
➕ Advanced Example: Retry Counter
- Add a
retryCounter
(integer) variable to handle failed API calls:-
Initialize:
retryCounter = 0
. -
Loop: Retry up to 3 times if an action fails.
-
🤔 Condition:
@if(less(variables('retryCounter'), 3), 'Retry', 'Alert Admin')
-
⚠️ Common Pitfalls to Avoid
- 🚫 Uninitialized Variables: Always declare variables before use.
- 📍 Scope Issues: Variables in loops/scopes reset unless explicitly passed.
- 덮어쓰기 Overwriting Data: Use
Append to Array
instead ofSet Variable
for lists.
🏆 By using variables strategically, you can build 🔧 flexible, ♻️ maintainable, and 📈 scalable workflows that adapt to dynamic business needs. Let me know if you’d like more examples! 🚀