Flow errors

(0) Share

Report

Posted on by VivB

Good day,

I need help and don't know where else to turn.

I am busy with a Powerapps course and have hit a snag I cannot figure out how to fix it and without the flow functioning the rest of the App does not work.

We are creating a receipt for a sale using a POS system we are building (model-driven and canvass). The flow is triggered from within our canvass app creating a sales receipt. The receipt records the cashier information, customer info, the amount for the sale, the amount tendered, and the change. These are all variables. We then use the Dataverse connector to get the customer information (Get Row by ID) using the contact table and the variable we created. I am attaching screenshots to show what I have done, the error I get, and then when I go back to inspect my fields, things are not the same as when I set it up.

I really would appreciate some help here.

The fields to create the receiptLast step, then savedError when testing the flowWhat the fields look like after the flow has run (the have changed)

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

Hey @VivB

Can you show what query you have written in get customer action?

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

I don't think you should worry about the fields "changing" like they are changing color. Power Automate does that sometimes when you have put in an expression. When you first make the expression, it doesn't register where the value is coming from, then after the flow runs it decides what the label should look like.

I've even seen it where I have put in something like item() in the expression, and PA makes the label look like a sharepoint item or something else in the flow, but it is still the item() expression.

Your lookup columns for contacts should have different format.
Read this post here about what to do with the contacts field.
https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Working-with-Dataverse-Lookup-amp-Choice-Columns-in-Power/ba-p/1912078

Here's an easier read:
https://angelogulisano.com/dataverse-create-item-with-lookup-field-power-automate/

Was this reply helpful? Yes No
VivB 27 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik,

Here are the screenshots of the Variable and then the Query for Get Customer

Was this reply helpful? Yes No
VivB 27 on at

Like (0)

Report
Copy link

Link copied!

I have solved the problem with my flow. Thank you all.

Was this reply helpful? Yes No