Answered

Getting a customer account details from Fin Ops using a flow

(0) Share

Report

Posted on by MonkeyAb

Hi everyone,

First time posting so I'm hoping someone can help 🙂
I am setting up a Power Virtual Agent Chat Bot for internal use. I want to be able to request a customer account number and Power Automate to then go and search D365 Fin Ops to find that Account Number and give me back the Customer name.

I have two issues;

1) It throws out an error even if the account number is correct.

2) When typing in the account number it removes any leading zeros which effectively changes the account number

original account number that was being searched was 004001

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

TaylorBecktold 295 on at

Like (1)

Report
Copy link

Link copied!

Hey @MonkeyAb -

I believe I can assist with issue #2, but this might fix issue #1 as well.

I recommend passing the account number as a string instead of a number. It is removing the leading numbers due to it assuming that is an integer value and integers typically do not have leading 0s.

Did my reply help? Please give it a thumbs up.
Did my reply answer your question? Please mark it as a solution!
If you liked my response, please consider giving it a thumbs up.
Check out my blog: https://azwhizkid.com/

Was this reply helpful? Yes No
MonkeyAb 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks Taylor.

So I found out my issue for error 1 was simply having a space when it shouldn't (amateur I know)
And you were right, I changed it to string and it maintained the format of the number without removing leading zero's.

Was this reply helpful? Yes No