cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gabrielv22
Level: Powered On

Send Collection data to SQL DB.

Hi All.

 

I try to use PowerApps Offline.

Therefore, I need to send the Collection data to SQL DB.

 

1. Save Data into Collection.

 

Collect(tmp_checklist_tosend;
{
vehiculo_patente: Input_Patente.Text
})
;;
SaveData(tmp_checklist_tosend;"temporary_tosend")

 

Collect.png

 

 

 

 

 

 

 

 

2. Send the Collection data to SQL DB (But I have a error)

 

ForAll(tmp_checklist_tosend;
Patch('[dbo].[Checklist]';
Defaults('[dbo].[Checklist]');
{
vehiculo_patente: tmp_checklist_tosend.vehiculo_patente
}))

 

 

 

Send.png

 

 

 

 

 

 

Error: The type of argument "patent vehicle" does not match the expected type "Text". Type found "Table".

 

Can you help me?

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabrielv22
Level: Powered On

Re: Send Collection data to SQL DB.

I use this:

Collect('[dbo].[Checklist]';tmp_checklist_tosend));;

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Send Collection data to SQL DB.

Hi @gabrielv22 

I think the reason this is happening is because tmp_checklist_tosend is a collection that can contain contain multiple rows.

One way to work around this is to select the first record from tmp_checklist_tosend using  the First function, as shown here.

 

ForAll(tmp_checklist_tosend;
       Patch('[dbo].[Checklist]';
             Defaults('[dbo].[Checklist]');
             {
             vehiculo_patente: First(tmp_checklist_tosend).vehiculo_patente
              }
)
)

 

 

gabrielv22
Level: Powered On

Re: Send Collection data to SQL DB.

I use this:

Collect('[dbo].[Checklist]';tmp_checklist_tosend));;

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 207 members 4,454 guests
Please welcome our newest community members: