web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Business Central filte...

Small and medium business | Business Central, N...

Suggested Answer

Business Central filter/insert customer with custom field using Power Automate

(0) Share

Report

Report

Posted on by DhavalKariya

5

I have created a power automate which is used to add customers from SQL. It's working properly, now the issue is We have couple of custom fields and we are not able to filter or insert record with custom fields.

e.g. Custom field name is Statement Type

and we try using create record but it's not accepting custom fields. Also, I wanted to check system name for the custom field as my field having a space.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 102,361 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, if you're using standard APIs, you can't use custom fields because they aren't available on the standard API page.

More details: Can we extend standard APIs? – Download Standard Source Code for APIs
https://yzhums.com/20960/

So if you need custom fields, you need to re-customize the new API, or use Odata (Web Service).

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 647 Super User 2026 Season 1

#2

Gerardo Rentería Ga... 447 Most Valuable Professional

#3

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans