Answered

How to import excel data into two different SharePoint Lists

(0) Share

Report

Posted on by nvpc1

I have one excel file that contains student names, class and grades. I want to import this data into two different SharePoint lists (Students and Grades)

I have created a flow that imports data into the Grades table but can't get the Students data to work as I only need one record per student.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @nvpc1 ,

I have a test for your reference.

Best Regards，
Dezhi

Was this reply helpful? Yes No
Unknown geen idee 1,757 on at

Like (0)

Report
Copy link

Link copied!

Dear nvpc1,

You can use the join() expression to create an array with only unique values, this should get you the result you want. For more details, check out the video: https://www.youtube.com/watch?v=tp0jLnmKcEs or do a search on how to configure the join() expression, there should be plenty instructions around.

Happy flowing,
Koen

Was this reply helpful? Yes No
nvpc1 6 on at

Like (0)

Report
Copy link

Link copied!

Many thanks!!!! very clear and easy to follow thank you again!! I thought I could do a loop within a loop 🙂

Was this reply helpful? Yes No
nvpc1 6 on at

Like (0)

Report
Copy link

Link copied!

thank you for your reply! I do follow Reza just didn't know he had a segment on this, he is a wealth of information. Thank you!

Was this reply helpful? Yes No