Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Unanswered

Need help! PVA reply when call action input is invalid?

(0) ShareShare
ReportReport
Posted on by 17

Hi all,

Please bare with me, I am totally clueless. I have no experience with coding or calling functions but i'm trying to get by with the vast amount of knowledge that is available.

Unfortunately I have run into an issue and I can't solve it.
I'm building a chatbot that finds (gets) a row from an excel sheet.
Triggerphrase = Contact details store
Question = Are you looking for the contact details of a store? Please type in the name of the store.
Identifier = User's entire response

Then is followed a power automate call action that finds the string in an excel sheet and outputs the store name, phone number and email address.
Now it all works fine, until the user inputs a store name that is not in the excel sheet. So lets say in my excel there are store names like "Big Shop Town, Lower part side Shop, Shopalicious'. But when I enter a store name thats not there i get a 2003 error and i get a few other error messages. 

My problem is: I can't for the life of me figure out how to add a function that recognizes the entry was faulty and the chatbot will ask a question like 'I cant find this store, do you want to search again?'. Because now the bot just kind of crashes and stops.
Here is my PVA flow & PowerAutomate Flow:PVA flowPVA flowHere is mHHere powerautomate_flow.PNG

 

Categories:
  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: Need help! PVA reply when call action input is invalid?

    I tried it now again, but with the following run after settings and it works also, thanks!

    TomDDD_0-1649337087973.png

     

  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Re: Need help! PVA reply when call action input is invalid?

    You can't have two return variable actions.  The two parallel runs should come together at the point of the return action.

  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Re: Need help! PVA reply when call action input is invalid?

    If you look at the error message it is saying it failed because the other set variable was skipped.  That's why the run after setting for the return action needs to be set to allow that set variable to be skipped.

  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: Need help! PVA reply when call action input is invalid?

    @Pstork1 this actually does work, correct input:

    TomDDD_0-1649313363666.png

    Incorrect input:

    TomDDD_1-1649313433927.png

     

  • TomDDD Profile Picture
    TomDDD 55 on at
    Re: Need help! PVA reply when call action input is invalid?

    @Pstork1 sorry for the confusion, but i had to create a new login because my old one didnt work anymore.
    I tried it again and now a correct input will give the site details.
    An incorrect input will give the error. Set Variable 2 won't communicate with the return value:

    TomDDD_0-1649312355392.png

     

  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Re: Need help! PVA reply when call action input is invalid?

    Remove The skipped check from the Variable 2 action.  That should only run if the Get Rows fails.  Otherwise it looks correct.  Can you provide a screenshot of what a run looks like?  The green check marks should help with troubleshooting.

  • TomDD Profile Picture
    TomDD 17 on at
    Re: Need help! PVA reply when call action input is invalid?

    @Pstork1 sorry i got confused, it will output when the SiteName is wrong, but give an error when the SiteName is correct. It can't seem to bring the values over to the variable...?

  • TomDD Profile Picture
    TomDD 17 on at
    Re: Need help! PVA reply when call action input is invalid?

    @Pstork1 alright, now it gets interesting. I added the run after setting as per your screenshot. But now, when I enter the correct site name it will output 'Site Not Found' and when I enter a wrong site name it will give an error..

    TomDD_0-1649278894017.png

     



  • Pstork1 Profile Picture
    Pstork1 64,907 on at
    Re: Need help! PVA reply when call action input is invalid?

    Based on the screenshot you haven't set the Run After setting on the return.  It should look like this.  If it was set there would be a little i in a circle like there is for the variable 2.

    image.png

  • TomDD Profile Picture
    TomDD 17 on at
    Re: Need help! PVA reply when call action input is invalid?

    @Pstork1  yes, im a bit lost now. After I set the Run after setting on variable 2 it stopped working also on the Site Not Found variable.
    This is the setup now, by logic i think it should work.
    I will try to rebuild it and see what happens.
    FOr now all run after settings have been set:

    TomDD_0-1649278161604.png

     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics