Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Building Flows / Problem creating table...
Building Flows
Unanswered

Problem creating table from Sharepoint List on Power Automate

(0) ShareShare
ReportReport
Posted on by Sbsyx 104
Hello,
I created a flow that retrieves content from a SharePoint list. All records were downloaded successfully. However, when I try to create a table, only selected records are included. Why?
Categories:
Business Process Flows
  • Sbsyx Profile Picture
    Sbsyx 104 on at
    Problem creating table from Sharepoint List on Power Automate
    Yes, ok. Data is retrieved correctly from other SharePoint lists.
     
     
    And code step select:
    {
        "inputs": {
            "from": "@outputs('LicencjeUKlientów')?['body/value']",
            "select": {
                "ID Subskrypcji": "@item()?['IDSubskrypcji']",
                "Informacja": "@item()?['Info']",
                "Nazwa": "@item()?['Nazwa']"
            }
        },
        "metadata": {
            "operationMetadataId": "cb6f284f-fef9-4b35-8942-e4764cc7c3e7"
        }
    }
    And get Sharepoint:
    {
        "inputs": {
            "host": {
                "connectionName": "shared_sharepointonline",
                "operationId": "GetItems",
                "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
            },
            "parameters": {
                "dataset": "https://xxx/sites/obslugaklienta",
                "table": "9822b123-861a-4458-a050-3d77e84f3c60",
                "$filter": "Zobowi_x0105_zanie ne 'Miesięczne'"
            },
            "authentication": "@parameters('$authentication')"
        },
        "runtimeConfiguration": {
            "paginationPolicy": {
                "minimumItemCount": 500
            }
        },
        "metadata": {
            "operationMetadataId": "6b68af2c-ff02-4108-9617-7eaa9746be6b"
        }
    }
     
     
     
     
     
     
  • Expiscornovus Profile Picture
    Expiscornovus 29,909 on at
    Problem creating table from Sharepoint List on Power Automate
    Can you share a screenshot of your full flow setup? This will help troubleshooting your issue.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,719

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans