web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by 226

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

 
I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    237,912 Most Valuable Professional on at

    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?

  • JJDunaid Profile Picture
    226 on at

    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
    André Arnaud de Calavon Profile Picture
    301,051 Super User 2025 Season 2 on at

    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
    226 on at

    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?

  • Deepak Agarwal Profile Picture
    8,602 on at

    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
    226 on at

    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!

  • Verified answer
    Martin Dráb Profile Picture
    237,912 Most Valuable Professional on at

    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
    226 on at

    Martin,

    Thanks, this quite helped me .

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans