Answered

How to import excel data into two different SharePoint Lists

Like (0) Share

Report

Posted on 14 Feb 2023 05:39:32 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:

Business Process Flows

All responses (4)

Answers (1)

nvpc1 6 on 15 Feb 2023 at 01:58:09

Like (0)

Report

Re: How to import excel data into two different SharePoint Lists

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!
nvpc1 6 on 15 Feb 2023 at 01:55:08

Like (0)

Report

Re: How to import excel data into two different SharePoint Lists

Many thanks!!!! very clear and easy to follow thank you again!! I thought I could do a loop within a loop 🙂
Unknown geen idee 1,755 on 14 Feb 2023 at 07:52:53

Like (0)

Report

Re: How to import excel data into two different SharePoint Lists

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
Verified answer

v-dezhili-msft Microsoft Employee on 14 Feb 2023 at 07:52:25

Like (0)

Report

Re: How to import excel data into two different SharePoint Lists

Hi @nvpc1 ,

I have a test for your reference.

Best Regards，
Dezhi