cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pinja
Helper I
Helper I

"Attribute ... cannot be NULL" error for optional attributes while importing data

I'm using the import wizard for importing data, but am getting this error for some fields, even if they aren't required (they're required in a business process, though). I could put some dummy values in but that seems silly. Any way to fix this?

12 REPLIES 12
pinja
Helper I
Helper I

Not completely sure yet, but it seems that the problem was that some business rules changed certain fields into required fields (e.g. if field A is true, then field B is required). Disabling those rules seems to have helped.

 

EDIT: It works!! Yay.

Samxx
New Member

I have getting the same error: Attribute 'name' cannot be NULL trying to import a solution to a new environment. I have been through all my columns and form names and everywhere I can think of and cannot find where this issue lies. I have no workflows or business rules, just several tables and forms in a solution. 

The output XML suggests the issue is in a form, but having checked the form, everything has a 'name'

Any ideas on how to go to resolve this, other than recreating all the tables and forms manually on the other environment, which will take days. 

Samxx
New Member

This is the XML output. Not sure if anyone would know where to look?

<Row ss:AutoFitHeight="0" type="Form">
                <Cell ss:StyleID="s137" name="Time">
                    <Data ss:Type="String">
                        09:14:25.01
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="ItemType">
                    <Data ss:Type="String">
                        Form
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="Id">
                    <Data ss:Type="String">
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="Name">
                    <Data ss:Type="String">
                        sk_Booking
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="LocalizedName">
                    <Data ss:Type="String">
                        Booking
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="OriginalName">
                    <Data ss:Type="String">
                        Booking
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="Description">
                    <Data ss:Type="String">
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="Status">
                    <Data ss:Type="String">
                        Failure
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="ErrorCode">
                    <Data ss:Type="String">
                        0x80040200
                    </Data>
                </Cell>
                <Cell ss:StyleID="s137" name="ErrorText">
                    <Data ss:Type="String">
                        Attribute 'name' cannot be NULL
                    </Data>
                </Cell>
            </Row>

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.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,932)