Forum Discussion

LewyNZ's avatar
LewyNZ
Regular Visitor
3 years ago

Sharepoint list run through power query (dataflow) generate a new share point list

I curently have a sharepoint list which I export to excel edit in power query then copy the data back to a new share point list. 

Is thre a way where I can do this without having to export to excel and then manually copy back to a new sharepoint list?

Ideally I want to add a buttom to my power apps app when clicked it runs the data flow from the share point list and generates the new sharepoint list from the output of the data flow.

Need Help

1 Reply

  • jbwtp's avatar
    jbwtp
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi LewyNZ,

     

    Not sure about Power Apps as I do not remember if there is a connector to PBI Dataflow. However, there is a way to do it and there are some good articles on how to integrate Power Automate buton into a PBI report.

     

    You can also investigate on the Internet how to use Web.Content() to send POST requests. This can be set to send HTTP POST to an HTTP connector in the Power Automate. A couple of years ago I implemented a performance tracker to get log of transactions in PQ using this technique. In this case you would not even need a buttton all will be done on PBI refresh automatically.

     

    Kind regards,

    John