web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Business Central - Get...
Power Automate
Unanswered

Business Central - Get Record (v3) Row Id

(0) ShareShare
ReportReport
Posted on by 53

Hi everyone, 

 

I have created a custom table and the related API page in Business Central and I can successfully see them in Power Automate when I use the Business Central Connector. My issue is occurring when I try to use the Get Record (v3) action as it is failing with ErrorCode: BadRequest_NotFound Bad Request - Error in query syntax. 

 

This is my Get Record action

 

yabela_0-1647524095393.png

 

The GUID of the BC record is stored in my Dataverse table (in a custom field so that I can refer to it anytime) and therefore I can pass it dynamically by choosing it from the Dynamic Content. But, whether I choose it from the Dynamic Content or input the GUID manually, I still end up with the same error. 

 

If I use Create Record action for the same table, it works fine so I do not think it is an API issue.

 

Any ideas what could be wrong here, please? 

 

Thanks in advance!

 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard