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 Online list, whit Unique vales, no duplicates

(0) ShareShare
ReportReport
Posted on by 106

Hi,

I was able to build this Flow fixing initial 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:

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 432

#2
11manish Profile Picture

11manish 313 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 154

Last 30 days Overall leaderboard