Conflicts Exist On Server

(0) Share

Report

Posted on by kent-culpepper

After weeks of building\ testing\ so on, I have not come across this error (attached) until now.. very odd.

I am building a Canvas App on Dataverse. My OnSelect is the following;

//Collect Records from Gallery where Changed

ClearCollect(
colEntriesHoldings,
ShowColumns(
Filter(
galEntries_Holdings.AllItems,
tglEdited_Holding.Value = true
),
"cr8cd_month_id",
"cr8cd_partner_name",
"cr8cd_entity_name",
"cr8cd_investment_group_name",
"cr8cd_investment_name",
"cr8cd_investment_name_import",
"cr8cd_cost_basis",
"cr8cd_market_value",
"cr94c_no_shares",
"cr8cd_entries_holdings_note"
)
);

//Patch Changed Records to Dataverse
ForAll(
colEntriesHoldings,
Patch(
Entries_Holdings,
ThisRecord,
{
Month_Id: cr8cd_month_id,
Partner_Name: cr8cd_partner_name,
Entity_Name: cr8cd_entity_name,
Investment_Group_Name: cr8cd_investment_group_name,
Investment_Name: cr8cd_investment_name,
Investment_Name_Import: cr8cd_investment_name_import,
Cost_Basis: cr8cd_cost_basis,
Market_Value: cr8cd_market_value,
No_Shares: cr94c_no_shares,
Entries_Holdings_Note: cr8cd_entries_holdings_note,
Calendar_Month: LookUp(
Calendar_Months,
Month_Id = txtMonth_Holding.Text
),
Investment: LookUp(
Investments,
Entity_Name = cr8cd_entity_name && Investment_Name = cr8cd_investment_name && Partner_Name = cr8cd_partner_name
)
}
)

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Is there a foreign key or alternate key that is causing this?
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
kent-culpepper on at

Like
a
(0)

Report
Copy link

Link copied!

I have one key created for that dataverse table. and i am testing with a single record.
kent-culpepper on at

Like
a
(0)

Report
Copy link

Link copied!

Its almost as if this table is corrupt in some way. I went back to my orig code (that I am using fine for 4 other galleries\ tables) which i put below. Its a very straight-forward procedure. It seems to come down to it not recognizing "Entries_Holdings" as a table in this context. One of the errors is "Invalid argument type (guid). Expecting a table value instead."

ForAll(
Filter(
galEntries_Holdings.AllItems,
tglEdited_Holding.Value = true
),
Patch(
Entries_Holdings,
ThisRecord,
{
Month_Id: txtMonth_Holding.Text,
Partner_Name: ddPartner_Holding.SelectedText.Value,
Entity_Name: ddEntity_Holding.SelectedText.Value,
Investment_Group_Name: ddIGroup_Holding.SelectedText.Value,
Investment_Name: ddInvestment_Holding.SelectedText.Value,
Cost_Basis: Value(txtCostBasis_Holding.Text),
Market_Value: Value(txtMarketValue_Holding.Text),
No_Shares: Value(txtNoShares_Holding.Text),
Entries_Holdings_Note: txtNote_Holding.Text,
Calendar_Month: LookUp(
Calendar_Months,
Month_Id = txtMonth_Holding.Text
),
Investment: LookUp(
Investments,
Entity_Name = ddEntity_Holding.SelectedText.Value && Investment_Name = ddInvestment_Holding.SelectedText.Value && Partner_Name = ddPartner_Holding.SelectedText.Value
)
}
)
))
Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I am looking now. As a favor, if you can paste code snippets using the </> in the bar, it makes it readable and easier hehe.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello again,

Queston: I notice that you are doing a patch every time they click the gallery. Is that really the intent? I am wondering if you are actually getting double patches.

Ok let's do this. Please follow the directions below. We need better details and only way to get it is the below.
Step 1. Close your App (stop it running)
Step 2. Click the Stethoscope in the Top Right
Step 3. On the bottom click Open Monitor
Step 4. Once Monitor is running go back and run your app
Step 5. Cause your issue to happen
Step 6. Close the app
Step 7. Go to the Monitor and Filter (top right) based on Error, or key word. Find the error line and look at the information Monitor has for why it failed.

Aside from looking for Error, you can also look up Patch too.

We need the details related to the Response (headers and body) for these calls.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
kent-culpepper on at

Like
a
(0)

Report
Copy link

Link copied!

Code is only executed @ Button\ OnSelect.

I followed your steps-- but since I changed back to my orig code (most recent reply)-- basically the Patch is not even executed-- as the code is in error. I want to reiterate- I use the same approach with 3 other tables, i.e. ForAll(Gallery,Patch()) w/o any issue. Something strange with this table in this context.
Verified answer

kent-culpepper on at

Like
a
(1)

Report
Copy link

Link copied!

The table was corrupted in some way. I had to recreate the table. And everything worked fine.