Finance | Project Operations, Human Resources, ...

Check for empty list in electronic reporting

(3) Share

Report

Posted on by CU15071409-0

I am trying to add vendor address to my positive pay file I created. I have added (what I think ) is the right address:

When I go to save it get this:

I go to add a formula to account for it, and I put this but I keep getting an error:

Any suggestions are appreciated.

kate

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Holly Huffman 6,538 Super User 2025 Season 2 on at

Like (1)

Report
Good morning, afternoon, or evening :) depending on your location!

The syntax error in your formula appears to be due to incorrect usage of brackets and parentheses, as well as a potential misunderstanding of how the IFISEMPTY function works. Let me walk you through the adjustments step by step.
Here's a corrected approach for handling the empty list case:

IF(
    ISBLANK(model.PositivePayTransactions),
    " ",
    model.PositivePayTransactions.'Vendor Address'
)
Key Points:

Function Names: Ensure you're using the correct function for the context. In Power Platform, ISBLANK or ISEMPTY checks if a list or value is empty.

Syntax Structure:

The IF function generally follows the format IF(Condition, Value_If_True, Value_If_False).

Use commas (,) to separate arguments instead of braces ({) or other symbols.

Handling Empty Lists:

If the model.PositivePayTransactions list is empty (ISBLANK or ISEMPTY), provide an alternative value like " ".

Otherwise, retrieve the 'Vendor Address' field.

Explanation:
This formula checks if model.PositivePayTransactions is empty. If it is, it outputs a space (" "). If not, it retrieves the 'Vendor Address' field.
If you still encounter issues, check:

The actual function names and syntax required for your specific environment (e.g., Power Automate, Power Apps, etc.).

Any specific data binding settings that might affect the formula.

Hope this helps!

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

I hope below can help

https://stoneridgesoftware.com/how-to-use-positive-pay-format-with-electronic-reporting-in-d365-finance-and-operations/?utm

https://learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/set-up-positive-pay-er?utm

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Adis 6,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You are missing a parentheses after the first ....vendor address') - this is also what the error message says.

If you wanna learn more about a function you can also access MS learn quite easily

ISEMPTY ER function - Finance & Operations | Dynamics 365 | Microsoft Learn

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No