XML feed data

Hi All,

I'm working on a Power Bi report that recieves data from two sources - a sharepoint list and an XML web feed. In Power Bi, I am transforming the data from the XML and appending it onto the sharepoint list data.

I would like to be able to store the data from the XML feed into the sharepoint list. What would be the best way to do this? Can I do this in Power Bi or am I safer using something like Power Automate to ingest the XML feed. Also, is there an easy way to only ingest new records from the XML feed?

Thanks

C