I have extended the Customer Table (18) in Business Central by adding a couple of fields.
I want to access these new fields in Microsoft Flow.
In Flow, at the time of Selecting an Entity, the Customer Entity that appears in Steps of flow has limited fields of Customer.
I would like my extended fields to appear.
Here is one of the ways I have tried approaching this but it does not really work out (I will explain why).
I created a Query of Customer Table in BC that had standard fields like No. and Name added to it, additionally, my extended fields let us call it newfield1 newfield2.
I exposed this Query as a web service in BC. In Flow, I created a new Entity as an ODATA connection to this Web Service endpoint.
I thought I could just drop the D365 Business Central trigger in my flow and use the CDS one. So instead of When a Customer is Created trigger of BC. I went ahead to use When a Record is Created in CDS and I chose my Query Entity.
This causes the flow to keep running continuously, I do not know why this flow keeps running even when there actually is no new Record being created in CDS.
I am sure there is a different approach I am unaware of which would let me move my extended table fields to the standard entities of CDS.
