cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EthanWang
Helper I
Helper I

Re: Import multiple CSV from folder monthly

Hi @Mira_Ghaly ,

 

Thanks for your suggestion,  but I am new to automate and could you please describe more specific how to set it up?  How do i apply each table column to match CDS/Table field since the file is dynamically increased into the folder?

 

My excel table is easy table content as attachment.

 

Many Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@EthanWang 

Please follow below the below steps after your trigger:

1. Call action": Get File Metadata

2. Call Action : Get Tables

3. Loop on Get Tables

4. Call Action Get Table Rows 

5. Loop in Get table rows and insert in CDS

Mira_Ghaly_2-1611891074411.png

Mira_Ghaly_3-1611891156094.png

 

 

Mira_Ghaly_4-1611891309598.png

 

To get Values from List Table Rows you need to use the Expression:

Mira_Ghaly_5-1611891853604.png

items('Apply_to_each_2')?['Broker'] where Broker comes in place of your field names as they are in the excel sheet.

 

Hope this works for you!

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

8 REPLIES 8
Mira_Ghaly
Dual Super User II
Dual Super User II

@EthanWang 

Here is a quick overview of how to loop on your excel records and insert in Data verse

Mira_Ghaly_0-1611886031098.png

Mira_Ghaly_1-1611886153160.png

 

Hope this gives you a quick idea!

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly 

How do i start with "when a file is created in a folder"?

 

EthanWang_2-1611887030694.png

 

EthanWang_1-1611886959220.png

 

Mira_Ghaly
Dual Super User II
Dual Super User II

@EthanWang 

You apply to each is on the Get Tables Action not Get Table Rows Action ->

Are you reading multiple tables or single table?

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Mira_Ghaly 

 

it should be single table, i delete the wrong step, 

EthanWang_0-1611887608620.png

 

Mira_Ghaly
Dual Super User II
Dual Super User II

@EthanWang 

I am testing on my side to try to get it working by picking file name when it is triggered on When a file is created or Modified.. I can get the file name through this action

Mira_Ghaly_0-1611889488778.png

 

But when i pass it to GetTables and GetTableRows it does it evaluate,  I am working on it and will update you if i had any luck.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Mira_Ghaly
Dual Super User II
Dual Super User II

@EthanWang 

Please follow below the below steps after your trigger:

1. Call action": Get File Metadata

2. Call Action : Get Tables

3. Loop on Get Tables

4. Call Action Get Table Rows 

5. Loop in Get table rows and insert in CDS

Mira_Ghaly_2-1611891074411.png

Mira_Ghaly_3-1611891156094.png

 

 

Mira_Ghaly_4-1611891309598.png

 

To get Values from List Table Rows you need to use the Expression:

Mira_Ghaly_5-1611891853604.png

items('Apply_to_each_2')?['Broker'] where Broker comes in place of your field names as they are in the excel sheet.

 

Hope this works for you!

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

@Mira_Ghaly 

 

It works! Thanks!😃

Hi @Mira_Ghaly ,

 

Here comes anther question,

 

after i update the file into Table, what if i have another parent Table the i have to set the relation?

 

I meant I have a column named "Account", and there is another Table that have each accounts detail named [Account List], as I know it seems hard to set relation directly while importing Excel file into Table, but if i can use something like filter query in automate to match the information in [Account List] then put it into this [AUM] Table?

 

Thanks,

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,379)