How to combined two share point lists

(0) Share

Report

Posted on by SwiftCrypt

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Hi @SwiftCrypt,
We Have Only Create csv table Based On columns That Present in Database List If Job Title matched of "New Hire Entry". Then delete the Csv File after each run?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @SwiftCrypt ,

The Job Titles column of New Hire Entry list seems like a LookUp column, isn't it? Besides, if you get all the items from both lists to generate the CSV table and create file, it will include all the new hire entries every time, which I think is not necessary. You can use a When a new item is created trigger for new entries in New Hire Entry list. So, every time a new hire entry is created in that list, the flow runs, and will get that one new entry only.

Flow steps:

1. trigger: When an item is created

2. Get items, filter query Title eq '(Job Titles Value from dynamic contents)'

3. Apply to each result of Get items

4. Compose to generate an array, use union expression to join the new entry together with the job title

[

union(outputs('Get_items')?['body/value']?[0],triggerOutputs()?['body'])

]

5. Select operator and map column names and values from trigger and get items action, choose columns based on your need.

6. Create CSV table use outputs of Select.

7. Create file, send Email, delete file.

Best regards,

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (1)

Report

Hello @SwiftCrypt,
- Taking 2 SharePoint lists and extracting data from them in the flow based on a single column
- I Have Created Sample for Your Query.

Was this reply helpful? Yes No
SwiftCrypt 16 on at

Like (0)

Report

How would I do this if I want to manually trigger it?

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Hi @SwiftCrypt,
You Can Perform Some Changes in Flow And add One Additional Column In your New Hire Entity List.

1. Add Column in New Hire Entity List with Name Status and Select Column Type Choice then set Default Value Field New.

2. Use Apply to Each Iterate on Value which return by Get items From Database Action.

3. Use Get items from New Hire Entity Action in apply to each and get data based on Performing Filter Query

4. Then Use Condition Action To check whether the Get items from New Hire Entity Action return any values or not.

5. if Condition is true Then All Steps Are Same As shown Above reply Instead of last apply to each 2 action that is only use for update status New to Old of New Hire Entity List Rows.

After this I guess you are good to go.

If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
SwiftCrypt 16 on at

Like (0)

Report

the get items from new hire isn't populating title I would have to custom text it or write it out completely the way you had it.

It's not even showing the list of column in the list. When using the line you gave me I always returned a false entry and nothing would appear but would run successfully. The "Title" column in New Hire is used as a lookup what's in the column "Title" in Database and match it.

Was this reply helpful? Yes No
Verified answer

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Hi @SwiftCrypt,
Please Modify Flow for matching lookup column.
1. Please Remove All the Filters in Get items from New Hire Entity Action.

2. After That Use Filter Array Action and Set From that value return by Get items from New Hire Entity Action.

3. Then Select Look Up Column value in left side Filter array.
Here Title1 Is look up Column in My List

4. After Use Edit in advanced Mode apply Both Condition Title1 and status.
@and(equals(item()?['Title1/Value'], 'Sam'),equals(item()?['Status'], 'New'))

5. Then Modify Left Side Value of Condition Action.

empty(body('Filter_array'))

After this I guess you are good to go.

Was this reply helpful? Yes No