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 / Copilot Studio / Getting Error 2003 Whi...
Copilot Studio
Unanswered

Getting Error 2003 While Adding Action Created in Flow

(0) ShareShare
ReportReport
Posted on by 6

Hi there,

 

I need some help here - I am creating a bot that can check product and price and return the all the value from Excel Online to the user, but I hit an Error 2003 when trying to pull the data. Please help me.

 

Image#1 PVA with the Action

image1.PNG

 

Image#2 Power Automate

image2.PNG

 

Image#3 Power Automate

image3.PNG

 

Image#4 Initialize Variable

image4.PNG

 

Image#5 

image5.PNG

 

Image#6

image6.PNG

I have the same question (0)
  • CU22081450-0 Profile Picture
    Most Valuable Professional on at

    Hi @esther-chan ,

     

    The filter query for Excel action (List rows) is wrong because you are using the "apply" text hardcoded.

    If you want to filter by Display Name, you need to have:

    "DisplayName eq 'YOUR_VALUE'" 

     

    Solved: examples of how to enter a filter query for excel ... - Power Platform Community (microsoft.com)

  • esther-chan Profile Picture
    6 on at

    Hi Renato Romao,

     

    Thank you for taking the time to help me out. I am still facing Error 2003 after amending the Filter Query in List rows. Do you know of any sites/blogs/vlogs that can show me step-by-step in creating a bot to check products and prices so I can do some reference?

     

    Image#1

    image7.PNG

  • PowerPuffKK Profile Picture
    316 on at

    Hi @esther-chan ,

     

    I can see a couple 'gotchas' in your flow which are likely to be causing the error:

     

    1) for the OData filter query, in your first screenshot it looks like your query is supposed to be an expression but the text has been hardcoded - in order for that expression to be valid, you'll need to click on 'Dynamic values' and then the 'Expressions' tab and type your expression there (which will then appear pink as you can see below). 

     

     

    PowerPuffKK_1-1636277994165.png

     

    I'm not sure how experienced or technical you are but if you're not familiar with writing expressions, you can use the new preview experience of expressions which is very user friendly. To switch it on, please click on the settings icon to the top right of your screen and choose 'View all Power Automate settings and then switch the 'Experimental features' on.

     

    PowerPuffKK_2-1636278063783.png

    Depending on your region, your filter query should look like this:

     

    PowerPuffKK_3-1636278222590.png

     

     

     

    2) Your apply to each action step - please could you show me all of the actions within that part? I can't see the expression you entered in the condition step but this could literally just be the value property in dynamic values (as this will return the list of items) and if that value is greater or equal to 1, you'll provide the user with a table of items, if false, then you'll respond to the user with a message that you don't have that specific CSP in your spreadsheet.

     

    PowerPuffKK_4-1636278804152.png

     

    More than happy to help further if needed 😊

     

    Kristine

     

     

     

     

     

  • esther-chan Profile Picture
    6 on at

    Hi Kristine,

     

    I would like to thank you so much for taking the time to read my post and provide a solution for me. I learned something new from you today about the "Experimental feature", as I am not very technical. I had removed the values in "Filter Query" temporarily to reduce the error on data pull by the bot. Here are the screenshot for the "Apply to each":-

     

    Screenshot from "Apply to each"

    Capture1.PNGCapture2.PNGCapture3.PNG

     

    Below is the bot result after some modification. It seems that I had missed out something that the bot can't return a true value.

     

    Capture4.PNG

     

    Thank you for helping me out again Kristine!

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 > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 261 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 230 Super User 2025 Season 2

#3
Sam_Fawzi Profile Picture

Sam_Fawzi 84 Super User 2025 Season 2

Last 30 days Overall leaderboard