Finance | Project Operations, Human Resources, ...

Add empty check for "List empty for field" in Electronic reporting D365FO

(0) Share

Report

Posted on by Rohin

4,624

Hi,

How to add empty check list for field in ER configuration format. I am getting lot of error for fields having no value. I don't want to throw errors if fields doesn't have value. Please suggest.

I have the same question (0)

All responses (7)

Answers (0)

Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Rohin,

Please read this thread:

community.dynamics.com/.../electronic-reporting-er---list-model-payments-does-not-have-any-check-for-empty-list-case-it-can-result-an-error-at-run-time-add-a-check-for-empty-list-case

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Thanks Blue , I've read that thread earlier but didn't success.

For example:- It is throwing an empty list error at "FirstName(String field)" shown below and i tried to add Empty check list condition in FORMAT designer as below :

Can you please suggest what it should be??

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Rohin,

"function arguments are of incorrect types in "isempty""

For IsEmpty function , the arguments should be list.

Check Compound expressions part:

docs.microsoft.com/.../er-formula-language

docs.microsoft.com/.../er-functions-list-isempty

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Rohin,

Isempty won't work on a single record because it checks for empty records in a list.

Maybe try with the len (length) feature to count the length of the first name and combine it with an if formula.

Something like .... if the len is 0 then do this and that...

Best regards,

Ludwig

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Thanks Blue and Ludwig.

I am little bit confused about below things , please suggest me :-

1. Where to add these check lists ? should I write this at "Format Designer" side or "Modal mapping" side??

2. Currently, I trying to write at "Format Designer" side.

let suppose for "FirstName" which is String field and ISEMPTY() function accept only "List" so how can i use ISEMPTY() function for this field??

OR

Like Ludwig mentioned , use LEN() as another function but i am not able to reference my node . can you please tell me correct way.

I'm to new to ER so little bit struggling with formula part and MS docs are not well explained with examples. any help really appreciated.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Rohin,

Transform data that is received from an application database and that should be entered in an ER data model that is designed to be a data source for ER formats. Such as filtering, grouping, and data type conversion.

docs.microsoft.com/.../general-electronic-reporting-formula-designer

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Rohin,

Can you try removing the single quotes?

Here is an example how this LEN formula works when I enter abc by selecting the TEST button/function.

Best regards,

Ludwig

Was this reply helpful? Yes No