Collect Function Not Recognizing Specific Column of Table

[dcoxi21]

Hey guys,

I'm building a PRA form to collect information regarding my company's projects. Thus far, I've put all the information into collections for better performance throughout the app. It's now come time to send it all to our database on SQL Server. I've written out my first collect statement and everything looks good except that the first column (ProjectID) is not being recognized. "Name isn't valid. Identifier isn't recognized." is the error I get. Here is my statement:

ForAll(ResourceCost,
Collect('[dbo].[ResourceCost]', ProjectID: projid,
RoleID: LookUp('[dbo].[LINEITEM]', RoleID),
DailyCost: LookUp('[dbo].[LINEITEM]', DailyCost),
ResourceProfessionalFees: LookUp('[dbo].[LINEITEM]', ProFees),
ResourceID: LookUp('[dbo].[LINEITEM]', ResourceID),
ProfitSharing: LookUp('[dbo].[LINEITEM]', ProfitShared),
LeadBonus: LookUp('[dbo].[LINEITEM]', LeadBonus),
CreatedOn: Now(),
CreatedBy: "POWERAPPS_PRA",
LastModifiedOn: Now(),
LastModifiedBy: "POWERAPPS_PRA")));

I've set projid to a variable that holds the ID of the selected project. All columns are recognized except for the 'ProjectID' and I've hit a wall on what could possibly be causing this. If you have any insight on what the issue could be, please help me out!

Thanks,

Dan

[dynamicsedge]

@dcoxi21 

1. Make sure ProjectID really is that column's name
2. Try removing the data source, then re-adding data source - see if this helps.

[v-yutliu-msft · Accepted solution]

Hi @dcoxi21 ,

Is ProjectID an unique field and be generated automatically?

If so, I suggest you use this field to compare not to update.

Try this:

ForAll(ResourceCost,
Patch('[dbo].[ResourceCost]', LookUp('[dbo].[ResourceCost]',ProjectID=projid),
{RoleID: LookUp('[dbo].[LINEITEM]', RoleID),
DailyCost: LookUp('[dbo].[LINEITEM]', DailyCost),
ResourceProfessionalFees: LookUp('[dbo].[LINEITEM]', ProFees),
ResourceID: LookUp('[dbo].[LINEITEM]', ResourceID),
ProfitSharing: LookUp('[dbo].[LINEITEM]', ProfitShared),
LeadBonus: LookUp('[dbo].[LINEITEM]', LeadBonus),
CreatedOn: Now(),
CreatedBy: "POWERAPPS_PRA",
LastModifiedOn: Now(),
LastModifiedBy: "POWERAPPS_PRA"
}
)
)

Best regards,