cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tracytran
Resolver I
Resolver I

No dynamic content with "List rows present in a table"

Hi friends, 

I would like to update the SQL table from excel file where stored in Sharepoint.  The excel file in Sharepoint will be modified as the time goes by and it will contain the existing and updated data.

I created this flow: 

tracytran_0-1632977004879.png

 

To config Insert rows, I need to map the column name. However, some columns appear the dynamic content with the column name. Some do not. I realized that the column does not suggest the dynamic content has INTEGER data type. Others giving suggestion are Varchar data type. 

 

tracytran_3-1632977240695.png

 

 

tracytran_1-1632977065852.png

 

Could anyone please help me to solve this issue? 

I highly appreciate your support.  

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @tracytran ,

 

You can try referencing the fields directly using expression and see if it works

 
@item()?['ExcelColumnName']
 
ericcheng_1-1632978916301.png

 

ericcheng_2-1632978941585.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @tracytran ,

 

You can try referencing the fields directly using expression and see if it works

 
@item()?['ExcelColumnName']
 
ericcheng_1-1632978916301.png

 

ericcheng_2-1632978941585.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

@eric-cheng 

 

Thank for your reply. It works like a charm. 

However, I think my flow has a problem and does not work as I want. Current flow inserts all rows in excel file to SQL tables, which has existed rows same as in excel file. It leads to duplicate data. What I want is SQL table have the same data with excel file and no redundant/duplicated data. 

 

Could you please help me to solve this issue? 

I highly appreciate your support.  

 

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!

Top Solution Authors
Top Kudoed Authors
Users online (2,555)