How do we use "Business Central Get item" action or an alternative action to lookup table row id based on filter/query? Example: creating sales order Business Central requires a customer ID and we only wish to create a new customer if their email address or phone number doesn't already exist .. otherwise reference existing id.
Could you please explain more details about your requirement so we would try to provide a proper workaround for you.
I believe he's asking (and I would also ask): what's the best way to find the "Row id" necessary to use the "Get record" action in the Business Central connector?
There is no search/filter/list action in the connector, and guessing the row ID based on info available in the Business Central UI is hopeless. For example, I looked for the row ID for a customer record in the customer record's page in the Business Central UI, in the HTML code of the page, and in the URL. Guessed at many things, none worked.
AFAIK there isn't a way (yet) to filter and search for items from Power Automate to Business Central, however it appears your biggest issue is finding the ["Row id"] field relevant to your record.
This is the $systemId field (field 2000000000) for a record, it is a GUID but will be read fine as text.
You can find this value for a given Business Central record by inspecting the page (Ctrl+Alt+F1) and scrolling down the fields until you see the $systemId field. It is a non-editible field that is unique to every record in Business Central.
When you create a BC record in Power Automate you can retrieve this value (the ["id"] field) from the created object. The best practice is to make note of it in your source system that calls the Flow, for example in Sharepoint having a field in your list called ["BC System ID"] or something.
You can then use this field to get your BC record.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Explore the latest tools,training sessions,technical expertise, networking and more.