Search code examples
listsharepointschemaazure-logic-apps

Sharepoint Lists retrieve schema LogicApp

Hi I have data in SharePoint lists. Then I'm storing this data on the csv, because all the fields are strings my BI tool can't read some of them. My questions is: Is that possible to retrieve SharePoint List Schema with the LogicApp? This will solve my issues, then I will use it in Databricks processing and will apply to the cvcs. Thank you!

Solution

  • You can get File Properties and Metadata using below connector actions:

    enter image description here

    You can get items in a list like below using Get items action in SharePoint connector:

    enter image description here

    Is that possible to retrieve SharePoint List Schema with the LogicApp?

    AFAIK, this is not possible, ,you do not have a SharePoint connector in Logic apps where you get the data schema. Microsoft-Document says which actions can be done. You can get metadata of file, file contents but not the Schema inside the file or list.

    But to use SharePoint connector you can follow below design:

    enter image description here

    Output:

    enter image description here

    then I will use it in Databricks processing and will apply to the cvcs.

    You do not need Databricks to transform data, You can get the content of the SharePoint list/file from the output of Compose Action. You can use JavaScript Inline connector to transform data.

    enter image description here