web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Error when pasting Exc...

Finance | Project Operations, Human Resources, ...

Unanswered

Error when pasting Excel lines into form grid

(1) Share

Report

Report

Posted on by CU17021638-0

10

Hi Experts,

I’m facing an issue while pasting records from Excel into a custom line table grid in D365FO.

My line table has a unique index on (LineNum, HeaderRef).

In initValue(), I assign default values when the user clicks New Line:
- LineNum is assigned starting from 1, and increases by 1 each time a new record is created.
- HeaderRef= Header.RecID After that, the user pastes records from Excel.

After that, the user pastes records from Excel.

If the pasted records also contain the same values (e.g., LineNum = 1 and HeaderRef = Header.RecId), I get this error message:
“Changes to a previous row cannot be saved until you fix a validation issue. Continue working until you’re ready to fix this.”
If the Excel file doesn’t contain that same combination, the paste works fine.

Questions:

How is this scenario handled in standard forms like PurchTable/PurchLine where pasting works fine?
Is there a way to detect paste in the form so I can skip default initialization?
What’s the best practice to avoid this duplicate issue (e.g., handling in initValue() or elsewhere)?

Thanks in advance for your help !

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (1)

All responses Img

All responses (2)

Answers Img

Answers (0)

CU17021638-0 10 on at

Like (0)

Report

Error when pasting Excel lines into form grid

Hi André,

Thank you for your suggestion. I tried moving the logic to the insert() method as well, but unfortunately I am still facing the same issue. The fields are empty when creating a new line. Could you please guide me if there’s something else I should try?

Was this reply helpful? Yes No
André Arnaud de Cal... 297,705 Super User 2025 Season 2 on at

Like (0)

Report

Error when pasting Excel lines into form grid

Hi,

Can you tell us if you used the initValue() on the form datasource? You can try to move it to the insert() method and check if the values are empty. Then only set the values.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Sohaib Cheema 878 User Group Leader

#2

André Arnaud de Cal... 681 Super User 2025 Season 2

#3

Martin Dráb 496 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans