Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
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

  • esther-chan Profile Picture
    esther-chan 6 on at
    Re: Getting Error 2003 While Adding Action Created in Flow

    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!

  • PowerPuffKK Profile Picture
    PowerPuffKK 316 on at
    Re: Getting Error 2003 While Adding Action Created in Flow

    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
    esther-chan 6 on at
    Re: Getting Error 2003 While Adding Action Created in Flow

    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

  • CU22081450-0 Profile Picture
    CU22081450-0 on at
    Re: Getting Error 2003 While Adding Action Created in Flow

    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)

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics