web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to read results fr...
Power Automate
Unanswered

How to read results from list rows present in a table ?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

After I list rows present in a table, how can I read the values from the results? 

I want to use value fields in each row to create a item in sharepoint list.

 

Here is my schema:

 

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "@@odata.etag": {
                "type": "string"
            },
            "ItemInternalId": {
                "type": "string"
            },
            "Tag": {
                "type": "string"
            },
            "Value": {
                "type": "string"
            }
        },
        "required": [
            "@@odata.etag",
            "ItemInternalId",
            "Tag",
            "Value"
        ]
    }
}
Categories:
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @Anonymous 

     

    Create columns in SharePoint list (Name according to your excel column).

    Use SharePoint Flow action- Create item and select site address and list.

    once you select list, your list columns will be displayed and supply value from dynamic content of list row present in a table.

    Annotation 2020-08-21 231509.jpg

    Thanks

    Hardesh

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I think your are referring to use all columns.   My Table has the tag name in tag column and value in value column.  How could I get the Value at row 6?

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @Anonymous 

     

    Specific row value can be fetch via condition action. Pls share your flow and excel screens.

     

    Thanks

    Hardesh

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Here is the table in excel.  

    I want to assign these values to a list with the same heading as head Column A 

    BMX_0-1598035816349.pngBMX_1-1598036011910.png

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @Anonymous 

     

    So basically you want to transpose tag column in SharePoint List columns and assign value under each tag. i got your point and This can be achieve through union function and variables. I will give you solution. 

     

    Thanks

    Hardesh

  • saten85 Profile Picture
    2 on at

    @Hardesh15 Did you get solution on this query?

  • MadiW Profile Picture
    2 on at

    Hey @saten85 - did you get a solution for this?? I have the same issue!! 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 330

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 123

Last 30 days Overall leaderboard