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

Updateif collection from a collection 'Incompatible type' error

Hi,

 

I want to update a collection with a value from another collection both of which are taken from SQL Server.

 

Error: 'Incompatible type. The 'Count_Qty' column data source you're updating expects text a 'Text' type and you are using 'Table' type.'

 

UpdateIf(Stock, Id=UserCounts.Stock_ID, {Qty_Count: UserCounts.Qty})

 

if it was an SQL query it would look like

 

UPDATE Stock
SET Qty_Count = u.Qty
FROM Stock a
JOIN UserCount u ON a.id= u.Stock_ID

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Bowdee
Level: Powered On

Re: Updateif collection from a collection 'Incompatible type' error

I've figured it out:

 

ForAll(UserCounts,UpdateIf(Stock, Id=Stock_ID, {Qty_Count: LookUp(UserCounts, Stock_ID = Id, Qty)}))

1 REPLY 1
Bowdee
Level: Powered On

Re: Updateif collection from a collection 'Incompatible type' error

I've figured it out:

 

ForAll(UserCounts,UpdateIf(Stock, Id=Stock_ID, {Qty_Count: LookUp(UserCounts, Stock_ID = Id, Qty)}))

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 74 members 3,878 guests
Please welcome our newest community members: