Unanswered

Create XML based an SharePoint list entries

(0) Share

Report

Posted on by Chriss1982

Hello all,

I´m looking for an approach to define different sitecolumns in a SharePoint list and then export this list to e.g. a XML file via Power Automate?
What I want to reach is, that the users can define all the meta data within the concept phase on their own and after that, I just link to the XML file within my script to create the sitecolumns.

I have the same question (0)

All responses (6)

Answers (0)

efialttes 14,756 on at

Like (1)

Report

Re: Create XML based an SharePoint list entries

Hi!

I guess you already explored the options of xml() function, right?

Hope this helps

Was this reply helpful? Yes No
Chriss1982 71 on at

Like (0)

Report

Re: Create XML based an SharePoint list entries

Hi @efialttes,

not yet. That seems to requries an Azure Logic apps somehow. I´m not that good in developing. I actually hoped there is a Power Automate soltuion or did I understand it wrong?

Thanks anyway!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Re: Create XML based an SharePoint list entries

Hi

You can invoke WDL functions in Power Automate, too. Just declare a expression

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

Hope this helps

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Create XML based an SharePoint list entries

Hi,

Are you looking to create a list with site columns via Power Automate?

Thanks

Was this reply helpful? Yes No
Chriss1982 71 on at

Like (0)

Report

Re: Create XML based an SharePoint list entries

Hi @abm,

what I actually want to do is following:
An user should be able to define a set of Sitecolumns in central SharePoint list for his own Sitecollection/list.
After that I want to export this set of metadata in a XML file and run a Powershell script, which creates this metadata/sitecolumns in the users list.

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Create XML based an SharePoint list entries

Hi @Chriss1982

To read from SharePoint you need Get List Items. Then you need to construct XML contents using the list items (String manipulations). Finally pass the XML string to HTTP request or without XML you could map the dynamic contents to HTTP requests.

From Power Automate you can execute HTTP requests to SharePoint to create columns and metadata.

Please see below links.

https://michalguzowski.pl/add-fields-to-sharepoint-list-using-flow/

https://michalguzowski.pl/create-sharepoint-list-using-flow/

This article explains how to run a powershell using azure functions. Yes that requires some programming knowledge.

http://johnliu.net/blog/2018/4/run-any-pnp-powershell-in-one-azurefunction-from-microsoft-flow

https://sergeluca.wordpress.com/2017/12/01/upload-and-run-a-remote-powershell-script-from-microsoft-flow/

Thanks

Was this reply helpful? Yes No