
Hi,
I have PowerBI data and a SharePoint List. If the PowerBI data has a record that is not in the SharePoint List, then I need the code, using a button, to create a new record from PowerBI to the SharePoint List while merging and/or patching the data automatically to the SharePoint List so I’m not having to re-enter it manually. I already have a create new record button that works, but I would like to integrate the “patching" of data.
For example, my dataset from PowerBI is IDNumber (I’m guessing I would use PowerBIIntegreation.Data)
And the data from the SharePoint List is PersonalNumber.
So kinda like using the NewForm command, but having values from a datasource populate, similar to EditForm.
Any help would be much appreciated.