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
Solved! Go to 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,
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,
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
251 | |
251 | |
84 | |
36 | |
32 |
User | Count |
---|---|
337 | |
260 | |
122 | |
72 | |
45 |