Power Automate to get all the Distinct Department & Country from Office365 in a SharePoint list

Like (0) Share

Report

Posted on 1 Sep 2023 06:25:48 by ParomitaDas2916

Hi folks,

Need help to create a Power Automate flow to get all & only the Distinct Country & Department names from Office365 in two different SharePoint list .one name as "Department_list" & another "Country_list"

Note : Office 365 has 30k+ users record, also Department & County field must have distinct values with no blank values in SharePoint.

It would be grateful if someone share a solution.

Thanks in Advance.

Categories:

Licensing

Flow Mobile App

Business Process Flows

I have the same question (0)

All responses (5)

Answers (2)

ParomitaDas2916 on 01 Sep 2023 at 07:30:18

Like (0)

Report

Re: Power Automate to get all the Distinct Department & Country from Office365 in a SharePoint list

Please correct me ,what wrong I have done in the flow step as I am getting "HR",in a SharePoint column with special characters not only the name HR

Please help me to resolve this issue.

Thanks in advance.

Was this reply helpful? Yes No
ParomitaDas2916 on 01 Sep 2023 at 07:18:23

Like (0)

Report

Re: Power Automate to get all the Distinct Department & Country from Office365 in a SharePoint list

Ok & please correct me the next step will be "apply to each action" output will be [body] of filter array then "Create item" action for SharePoint list department value will also be filter array value.

Please correct me ,if I am wrong

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on 01 Sep 2023 at 07:12:17

Like (1)

Report

Re: Power Automate to get all the Distinct Department & Country from Office365 in a SharePoint list

Hi @ParomitaDas2916,

Was this reply helpful? Yes No
ParomitaDas2916 on 01 Sep 2023 at 07:03:04

Like (0)

Report

Re: Power Automate to get all the Distinct Department & Country from Office365 in a SharePoint list

Thanks ,Qi for the solution it is working .

But I need another help .it also showing a "null" in compose .I wants to remove null value & create item in a SharePoint list in a department column.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on 01 Sep 2023 at 06:38:10

Like (1)

Report

Re: Power Automate to get all the Distinct Department & Country from Office365 in a SharePoint list

Hi @ParomitaDas2916,

Here is a detailed flow:

Update here:

Sorry for the previous mistake.

So you already have two listes including duplicated departments and countries?

You need to list the distinct departments and countries?

Was this reply helpful? Yes No