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

Notifications

Announcements

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:
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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard