Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Common Power Automate Errors - SOLVED

(0) ShareShare
ReportReport
Posted on by 83

Hey Guys, 

I've recently gotten more into Power Automate and I just love it - the functionality is crazy. However, I am not loving the lack of documentation for errors. So here are the most common errors I've come across, some best practices & how to fix that super annoying reference error for lookup values. 

0x80040265 Error - Message: String was not recognized as a valid Boolean.

I received this error when I was trying to use option sets to filter my data, but I was using 0/1 vs true/false. Filters should be ODATA queries like new_ishubspotlead eq true NOT new_ishubspotlead eq 1. 

Dataverse Search Rows (Preview) uses relevance search, so what I would recommend is a filter based on rows. I did just the first record, since the top result from relevance is usually the most accurate. 

pastedimage1658933817635v5.png

HOW TO RESOLVE TEXT TO LOOKUP ERRORS: 

First thing you find is that Power Automate wants the plural form of your entity & the GUID. ex, /systemusers(GUID). You may not know how to get the plural name, because sometimes it isn't as easy as account(s). Sometimes it's more complicated, like transactioncurrencies from Transaction Currency field. What you want to find is the collection name in the solution layers. (how?) in classic, select your entity, select Solution Layers, then look at the system layer - you'll see a collection name. This is the name to use in Power Automate with the formatting /pluralentity(GUID). This is the most direct method I've found so far.

pastedimage1658932506828v1.png

pastedimage1658932539519v2.png

You might ask, what's a GUID - that's the records unique ID. Power Automate tries to call it out, but you can also find GUID's based on (Value) indicators. Such as: 

pastedimage1658932966632v3.png

OR

pastedimage1658932989270v4.png

  • Perry H Profile Picture
    Perry H 83 on at
    RE: Common Power Automate Errors - SOLVED

    That's super useful on this thread! thank you!

  • Bipin D365 Profile Picture
    Bipin D365 28,959 Super User 2024 Season 1 on at
    RE: Common Power Automate Errors - SOLVED

    Hi,

    Thanks for sharing.

    Check out below article on how to auto generate filter query for power automate

    saralagerquist.com/.../

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

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…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans