33
Hi Guys
I populated powerapps Gallery from Power BI report using PowerBIIntegration.Data object.
Can you please advice how to insert data from this gallery to an SQL Server table?
Thank you
If creating new records then use the Collect function, it is quite efficient.
You can use something like:
Collect( dbo.MyTable, Gallery1.AllItems )
You may need a ShowColumns around the Gallery1.Allitems to clean the data from unneeded columns.
If updating existing records then Patch will do the trick but is less efficient for creating new records.
Share
Report
All responses (
Answers (
