Answered

Complex flow for extracting data

(0) Share

Report

Posted on by Govind_Prajapat

Hi,

I have an Excel Sheet. It contains information about a the districts in different countries. It has Mainly three fields Country, States, and Districts. The country has different states, the state has different districts. The excel contains one record for each district. Now i want to import this data in SharePoint using Power automate flow in such a way that The data of countries goes to a list called "country" which is created on SharePoint without being duplicated. The data of states goes to a list called "state" with its country name as well. Here the state name is not to be duplicated. The data of districts goes to a list "District" with its country name as well as its state name. How can i do it in power automate.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Matthy79 4,182 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Govind_Prajapat ,

„union“ can be your friend for this problem.

I would read the excel sheet.

List 3 is just apply to each.
For list 1 and 2 you use select to select the fields you want and add a compose afterwards with the formula „union(YOURARRAY,YOURARRAY)“

Instead of YOURARRAY you put in the output of the select action. After that you can apply to each and the 3 lists are ready.

Was this reply helpful? Yes No
Govind_Prajapat 14 on at

Like (0)

Report
Copy link

Link copied!

Hi @Matthy79 ,

Thanks for your response.

Was this reply helpful? Yes No
Matthy79 4,182 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Govind_Prajapat ,

I thought I already did. Where do you have troubles? With the "select" or the "apply to each" or don't you know how to add items to a Sharepoint list. That would be "Create item".

Was this reply helpful? Yes No