Answered

Data Conversion Issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am getting an error regarding data type. I am saving two fields in the collection, Feature_ID and CPI_Name_ID. I have multiple rows in the collection So i understand that I have to use ForAll to Patch. I have written the following code

ForAll(CFeatureSelection, Patch('[dbo].[Feature_B_Tab]', Defaults('[dbo].[Feature_B_Tab]'),{Feature_ID:CFeatureSelection.Feature_ID, CPI_Name_ID: ABCScreenCast.CPI_Name_ID}))

CFeatureSelection and ABCScreenCast are Collections. CFeatureSelection has two fields, They are of Type Int in SQL Server database, When i type the code above, i get the following error

I am not sure how to convert the data from Collection to int data type? Can someone please help ? thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

timl 36,682 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

I'm not exactly sure but I think something like this will take you closer.

ForAll(CFeatureSelection, Patch('[dbo].[Feature_B_Tab]', Defaults('[dbo].[Feature_B_Tab]'),
{Feature_ID:Feature_ID,
CPI_Name_ID: First(ABCScreenCast).CPI_Name_ID
}
) )

For each record in CFeatureSelection, this formula will insert a record in [dbo].[Feature_B_Tab] with a FeatureID that matches the FeatureID for the current record in CFeatureSelection. Since ABCScreenCast is a collection, the formula will insert the CPI_Name_ID of the first record in the ABCScreenCast collection.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @timl
Basically "CFeatureSelection" in my code is Collection too. So I have used the code you suggested but unfortunately it is not working.

It there any simple way to do Type Casting in PowerApps ? It should be pretty simple to cast String data from Collection to INT something like in any other programming language ?

Was this reply helpful? Yes No
Verified answer

timl 36,682 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

The Value function converts a string to an int.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-value

If CFeatureSelection.Feature_ID is a string and [dbo].[Feature_B_Tab].[Feature_ID] is an int, this is the formula you would use.

ForAll(CFeatureSelection, Patch('[dbo].[Feature_B_Tab]', Defaults('[dbo].[Feature_B_Tab]'), {Feature_ID:Value(Feature_ID), CPI_Name_ID: First(ABCScreenCast).CPI_Name_ID } ) )

Was this reply helpful? Yes No