Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Bad Request - Error in query syntax.

(0) ShareShare
ReportReport
Posted on by 4

Hello

 

I am trying to get data from a Dataverse table when an new Form response is made. 

I get the error: 

Bad Request - Error in query syntax.

 

I can't seem to figure out if I get the error because I use the wrong row-id or why the issue is happening.

 

In the Microsoft explanation (https://docs.microsoft.com/da-dk/power-automate/dataverse/get-row-id) they use a string with numbers and letters as their Row ID, but I can't seem to find a similar ID for my row. Where do I find this?

Can someone help with this? 

 

KristianWR_0-1627549248063.png

 

  • ernu Profile Picture
    ernu 140 on at
    Re: Bad Request - Error in query syntax.

    I'm getting ID data from power apps because of my records are coming over power apps with "ID" column. but I have still same problem and I can not see "Data" setting in the Table screen. How can I find it?

  • Checkers Profile Picture
    Checkers on at
    Re: Bad Request - Error in query syntax.

    Hi Karl_F,

     

    Yes you can. Whether you do an update or a create or a trigger, you can look for the id by simply clicking inside any "input".  Make sure you are on the dynamic tab. Then scroll down until you see the Green section(s) of any dataverse actions. Look for the action with the name you gave it.

     

    Then scroll through the values. You will see the row id and you will see the GUID (unique id) . Here is the Unique ID (not the row id) the row id was further down. You can always tell the GUID as its got the same name as the table

    Sorry I blanked out the name, but it does match the Table Name 🙂

    Checkers_2-1663805817433.png

     

     

     

  • Karl_F Profile Picture
    Karl_F 18 on at
    Re: Bad Request - Error in query syntax.

    Hi,

     

    Is there a way to get this GUID without going into Power Apps. For example, can it be retrieved from within Power Automate i.e. if the trigger was a new row being added to a Dataverse table is there a way to grab the GUID of this new row from within Power Automate in the same flow?

  • KristianWR Profile Picture
    KristianWR 4 on at
    Re: Bad Request - Error in query syntax.

    Thank you! It works now 🙂

  • Verified answer
    Re: Bad Request - Error in query syntax.

    Hi @KristianWR :

    vbofengmsft_0-1627629059426.png

     

    vbofengmsft_1-1627629083339.png

    You could find the id of this record in the address bar.

    Best Regards,

    Bof

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics