web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Save Microsoft Message...
Power Automate
Unanswered

Save Microsoft Message Center data in a SharePoint list with Unique vales no duplicates

(0) ShareShare
ReportReport
Posted on by 106

Hi,

After some trial, I finally created this Flow fixing all the errors. Here it is:

arindam40_0-1646597683476.png

The first Get Item is initializing the SharePoint list & then selecting Column 'Title' just to capture the Message numbers, that are already saved in the SharePoint list.

After that, I am calling Graph API, to collect all messages parsing JSON value & again selecting (Select 2) only the 'id' values from it.

I checked, both are holding data like this:

arindam40_1-1646597907666.png

Everything is ok till here.

Then I apply the first condition, for each output from Select 2, where I compare both outputs(Select 2 with Select 1) & if unique, not duplicate, then save it to the Array variable. Here is how it looks like:

arindam40_3-1646598120333.png

 

And this works, which will show data after I run it:

arindam40_2-1646598090495.png

 

Next, I am setting up the final condition, that if the API collected value contains the unique value collected in Stored data array variable, meaning, if both ID matches, then create a SharePoint item in the list provided, as shown:

arindam40_4-1646598473254.png

All is good.. The Flow completes successfully. But the Actual SharePoint list does not receive any new data. The list has data till 20th Feb. So I know there are new Unique items there, but its not creating items.

Any thoughts, where I am going wrong?

 

Thanks

Arindam

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard