cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
genarich
Helper V
Helper V

Excel like Grid Form cannot accept null values

Hi,

 

I am trying to build an excel grid like form that mirrors how excel works. I was successfully able to edit, add, and delete a line item. However, when I try to edit it and change the cell into null values (no values), it did not accept it.

 

For example, if I delete the number values on the below item

1st step

genarich_0-1632325008303.png

2nd step

genarich_1-1632325084571.png

3rd step

Click on Save and exit grid view

genarich_2-1632325134557.png

 

It did not accept the null values as the value from the SP data source did not change. Please if anyone knows the workaround or solution on this, I would really appreciate! Thank you.

 

4 REPLIES 4
eka24
Super User
Super User

Check the Column in the sharepoint list if it is Required.

You can uncheck it to No in sharepoint for it to accept null

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

 

Yes, I already set those in SP list settings.

 

genarich_0-1632326861451.png

genarich_1-1632326923285.png

 

eka24
Super User
Super User

What is the formula for saving and what is the error message?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Here is the formula

ForAll(
    Filter(
        Gallery2_9.AllItems,
        Toggle2_9.Value = true
    ),
    Patch(
        'MP Excel - MP009',
        ThisRecord,
        {
            Date: DatePicker1_14.SelectedDate,
            'Total Submissions Received': Value(TextInput2_18.Text),
            'Total Submissions Expected': Value(TextInput2_22.Text),
            'Total Received (Previous Month)': Value(TextInput2_23.Text)
        }
    )
)

 

There was no error. It just retrieves the old number that was saved after hitting on the Save button, which should not be the case because I already have deleted it. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,771)