M365 User Profile Data

(1) Share

Report

Posted on by NP-18101421-0

237

Hi,

I am building a flow that runs everyday to pull User Profile data from M365 using a Power Automate flow. I have the following flow already working but I noticed that the file output is only pulling in last names up to M. After that it doesn't pull in the rest of the names. I also noticed that the flow pulls in a few different emails per user which isn't necessary. The company has about 4-5k employees but the output of the file is around 10k. How can I filter the output to only pull the data that contains emails ending in "gmail.com" and also make sure that all 4-5k employee user profile data is being pulled in? The pagination is already set to 5000.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NP-18101421-0

A couple of things

1. You need to go into the settings of the Action and turn on Pagination or it will only at most pull 1000 which would then let you pull 10,000

2. You could then add a Filter Array, using the output of #1 as the input, and the filter would be

Now the output of the Filter Array are the ones with gmail.com

You could also use Graph API, but ugg no need

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like
a
(0)

Report
Copy link

Link copied!

@Michael E. Gernaey

I added in the filter array, but not sure what the inputs need to look like afterwards for the other actions, can you help me with this?

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like
a
(0)

Report
Copy link

Link copied!

@Michael E. Gernaey whenever you have the chance can you please review my last post? I wasn't able to get it working so, I am thinking I need to change the inputs of the actions that come after adding the filter array like you suggested.

Appreciate your help in advance!

Was this reply helpful? Yes No