list rows present in a table

Like (0) Share

Report

Posted on 18 Dec 2022 03:14:55 by tanveal

235

Hi,

Basically, I am trying to append existing sharepoint list with additional data from a file dropped in SharePoint library.

Both, the SharePoint list and file in library have columns aligned. ( Title, Trader, Trade Date....etc).

I have below output from "list rows present in a table" action showing columns from sharepoint library file that needs to be added to SharePoint list.

Right now, all the columns from "list rows present in table" goes to "Title" column in sharepoint list. How can I separate the output so that each column data from file goes to the respective column in sharepoint list ?

I have the same question (0)

All responses (13)

Answers (1)

Pstork1 68,271 Most Valuable Professional on 18 Dec 2022 at 03:25:54

Like (0)

Report

Re: list rows present in a table

List Rows present in Table simply retrieves the rows. You need a create Item to create new rows in a SharePoint library. Each value from the list rows will need to be inserted in the corresponding row in a create item for SharePoint.

Was this reply helpful? Yes No
tanveal 235 on 18 Dec 2022 at 14:31:26

Like (0)

Report

Re: list rows present in a table

thanks, I am not using hardcoded file or table path as an option in list rows present in a table. Instead I have below, so when I create GET Item, it doesn't give me option of selecting individual columns.
The reason I am not providing a static path to the file and table is because once I replace the file each day, I have to relink the table otherwise lfow cannot find the table.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on 18 Dec 2022 at 15:22:45

Like (0)

Report

Re: list rows present in a table

Hi @tanveal,
could you please share me screen shot of create item Action.

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on 18 Dec 2022 at 18:37:23

Like (1)

Report

Re: list rows present in a table

The problem is that with a dynamic table you won't have access to the schema of the file. That's why you don't have access to the individual values. If the table always has the same columns you should be able to take the List Rows output and run it through a Parse JSON to get access to the column elements. Without that schema there is no way to transfer the rows to SharePoint.

Was this reply helpful? Yes No
Verified answer

Amit_Sharma 1,569 Super User 2024 Season 1 on 18 Dec 2022 at 19:48:00

Like (1)

Report
Re: list rows present in a table

Hi @tanveal,
I have created sample for you.

1. After the Get Tables Action, you can Use one Apply to each Action.

2. Then Use List rows present in a table and provide Table Name in Table Field Which return by Get Tables Action.

3. After that you can use one another Apply to each 2 Action and pass value in field.

outputs('List_rows_present_in_a_table')?['body/value']
4. Then Inside the Apply to each 2 Action use can You Create Item Action for Populating All Column Value that return by excel table.

items('Apply_to_each_2')?['Name']

Name is column name inside of excel table.

Complete Flow

-----------------------------------------------------------------------
Did I answer your question? Please Mark my post as a solution
If you liked my response, please consider giving it a thumb up

Was this reply helpful? Yes No
tanveal 235 on 19 Dec 2022 at 02:57:26

Like (0)

Report

Re: list rows present in a table

thanks Amit. However, I am getting the below error.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on 19 Dec 2022 at 06:54:17

Like (0)

Report

Re: list rows present in a table

Hi @tanveal ,
please try to enter value in Apply to each 2 from dynamic section. please show me complete pic of both apply to each Action in edit mode.

Was this reply helpful? Yes No
tanveal 235 on 19 Dec 2022 at 15:48:43

Like (0)

Report
Re: list rows present in a table

Please see below
The problem seems to be in list row present in table, which is the value of the "Apply to Each 2"

outputs('List_rows_present_in_a_table')?['body/value']

Was this reply helpful? Yes No
tanveal 235 on 19 Dec 2022 at 16:27:47

Like (0)

Report

Re: list rows present in a table

Yes, the table always has same columns. Could you shoe me an example where I can take List Rows output and run it through PARSE JASON to get access to column elements ? I am not sure how this would be done. thank you so much.

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on 19 Dec 2022 at 17:41:27

Like (1)

Report
Re: list rows present in a table

Build the flow once using hard coded file and table names. Use the output of the List Rows on the first run to generate the schema for the Parse JSON. If the columns are always the same the schema won't change. After doing that you can switch out the List Rows to use the dynamic file and table name. Here's a screenshot of an example.

After the Parse JSON you can see that the individual column values are available to be selected from the array. The entry for the content in the Parse JSON is

outputs('List_rows_present_in_a_table')?['body/value']

Which is the value array output from the List rows present in a table.

Was this reply helpful? Yes No