Find Duplicate Items in SharePoint List- Power Automate

I think this could work for other Data Sources like dataverse as well.
Case Use: I used this to make sure duplicate appointment records did come over from the MS Bookings platform when I needed to do a large migration of the data  using power automate and the Microsoft Graph API.  Flow would bomb out and I think started again at the record it left off causing around 100 dups.

This flow helped me ID the duplicates and since there wasn't too many I went it and deleted in the list itself.  You could add a "Delete Item" action to this flow to do it for you.

 

 

Smarty Streets- Verify your mailing addresses in dataverse with Power Automate against USPS- Power Platform

Use case: Verify mailing addresses are valid with the Unites States Postal Services before mailing out large quantities of piece mail or check payments.  Thus reducing mailing returns.
In this flow I am doing a bulk address standardization. You would really only need to do that once and then maybe use an "Update" row after that.

First you will need a Smarty Streets account. You can try a trial version to test if this solution is best for you.

Power Automate- Child Flow error- cannot be used as a child workflow because it is missing a response action

 Cannot be used as a child workflow because it is missing a response action

Follow these instructions

Add the action "Respond to a Power App or flow"

Add "Text" output

First Field: Status

Second Field: Done

Power AutoMate Saving error- child flows - Not saving

cannot be used as a child workflow because child workflows only support embedded connections

 

If your flow is not saving and it is connected to a child flow.  Follow the below!

 

Fix it by going to the "Details" of your flow,

on the bottom right side look for "Run only user"
Click "Edit"

Change the "Connections Used" from "Provided by run only" to a connection you created.

 

 

:) Smiles
 

PostMan- PowerSchool - Office365- Custom Connectors P4

Part 4

Power Platform Custom Connector
(I always build my stuff in Solutions, click here for more information about PowerPlatform Solutions)

1. Create and Name the Custom Connector

2. Scheme = HTTPS

3. Host is 

PostMan- PowerSchool - Office365- Custom Connectors P3

Part 3

Create a Bearer Token to make API calls using PostMan 

(You should have your newly installed plugin available to copy and paste Client ID and Client Secret)

PostMan- PowerSchool - Office365- Custom Connectors P2

Part 2

Install the Plugin in PowerSchool

  1. Log in to your PowerSchool Admin account 
  2. Select System under Setup in the main menu 
  3. Select System Settings under the Server section 
  4. Select Plugin Management Configuration 
  5. Click Install 
  6. Select the plugin file (XML) you just created to install 
  7. Click Install 

 

Part 3>

PostMan- PowerSchool - Office365- Custom Connectors P1

Part One

Create the Plugin for PowerSchool for Office
(Thank You BlayneC

Twig hard coded image with link field conditional Drupal 10

If you need an Image hard code such as a social media icon, but only want to display when a certain link field is filled out.... Here's your twig code.

My link field is field.hudl.url replace it with your link field.

The twig:

<div id="social">
{% if content.field_hudl_link is not empty %}

Twig render image field Drupal 9 Template

  <div class = "image"> 
   Zoe
{% set image_url = file_url(node.field_YOUR_FIELD.entity.getFileUri()) %}
  <img src="{{ image_url }}") >
  </div>

Pages

Subscribe to Melinda Cozza - Power Platform and CMS Developer RSS