Object Reference not set to an instance of an object.

[Bansari_Pandya]

Hello Team,

Hope you are doing well.  I am facing an error "Server Response: Object Reference not set to an instance of an object" while integrate power apps with F&O.

'ROLL NO' field data source is 'Mullen Bursts.' and for 'ALL ROLL NO' field data source is 'SOLSalesLineSerialLinks.' 

When I select value from 'ALL ROLL NO' field, it will lookup existing records. 

on field '1'  Items Property:

LookUp(MullenBursts,inventSerialId = DataCardValue19.Selected.'Serial number',Result1)

Here, MullenBursts--> DataSource of "ROLL NO" field

DataCardValue19.Selected.'SerialNumber --> "ALL ROLL NO" control name

Result 1 --> field in Mullen Burst

App is working fine. But when I play the app, initially it will show me the following error:

As per my understanding, Error will display due to null reference passes to the data source at initially. If I set !ISBlank() function how can I set as my formula contains more than one data source. Or any other option to restrict the power apps to pass null record to DataSource.

Thanks in Advance!

[v-yutliu-msft · Accepted solution]

Hi @Bansari_Pandya ,

Do you want to avoid the situation when DataCardValue19.Selected is empty?

If so, I suggest you add a justification for this.

Try to set the textinput's Default like this:

If(IsEmpty(DataCardValue19.Selected),"",
   LookUp(MullenBursts,inventSerialId = DataCardValue19.Selected.'Serial number',Result1)
)

//use IsEmpty to justify whether you select item in datacardvalue19. If not, the lookup function will not perform.

Best regards,