Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

How to delete blank rows from my form grid view.?

(0) ShareShare
ReportReport
Posted on by 208

When I used to add new data in my form a blank row  is added whether I have saved it or not how can I remove empty rows from my Grid.

Also I have set datatsource "Insert if empty" property to No.

.unnamed.png_2D00_640x480.png_2D00_374x342.png_2D00_640x480.png

 
  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: How to delete blank rows from my form grid view.?

    Martin,

    Thanks, this quite helped me .

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,842 Most Valuable Professional on at
    RE: How to delete blank rows from my form grid view.?

    If you don't want several new rows, simply don't create them.

    For example, if you press New button three times, you'll get three rows. If you want just one, press the button just once and not three times.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: How to delete blank rows from my form grid view.?

    Hi Deepak,

    I just want to restrict  empty rows appearance  and don't want them  to appear again .

    if I haven't added any data why are these empty rows suppose to appear?

    I hope you understand what I am saying!

  • Deepak Agarwal Profile Picture
    Deepak Agarwal 8,564 on at
    RE: How to delete blank rows from my form grid view.?

    Hi Junaid,

    Initially you asked how to delete these rows, which I guess sorted now. I am bit confused when you asking to control empty rows, what exactly you are trying to achieve.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: How to delete blank rows from my form grid view.?

    hi Andre,

    I do have a delete button  and yes you are right it disappears when I delete or refresh it , but is there any way from which I can control these empty rows?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    RE: How to delete blank rows from my form grid view.?

    Hi JJDunaid,

    It is expected behavior that there will be a new row added when you click on NEW. When you don't make any changes, then indeed the records will not be inserted in the database.

    If you have an action button for Delete on your form, you can use this to remove it without refreshing. A shortcut for this action is Alt+Delete.

  • JJDunaid Profile Picture
    JJDunaid 208 on at
    RE: How to delete blank rows from my form grid view.?

    Martin,

    YES ,It adds blank rows the number of times I click on NEW , but I never saved any of it.

    but when I refresh it ,the extra blank rows disappears.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,842 Most Valuable Professional on at
    RE: How to delete blank rows from my form grid view.?

    Are you saying that you can create a new row, don't save it and create an extra row? And if you don't save either and refresh the form, these records won't be there?

    This is the standard behavior of F&O grids, isn't it?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans