Non-unique data

(0) Share

Report

Posted on by CU22100725-0

129

Hi there,

I have an app that uses a delivery and billing system. In this system, a service can have the same name several times in different orders.

When I invoice, I need to be able to select the service and then display the invoice for that service.

At present, I filter my invoice using this formula:

Filter(
 'CRM - Facturation';
 Client.Client = Choix_Cde_Client.Selected.Client && Commande.Commande = Choix_Cde_Cde.Selected.Commande && Prestation.Prestation = Gallery_Presta.Selected.Prestation;
 'Ligne/Tâche'.'Ligne/Tâche' = Choix_Cde_LigneTache.Selected.'Ligne/Tâche'
)

This allows me to see only those invoices that are linked to a customer, an order, a line/task and/or a service.

There is a screenshot to help you understand:

There should only be one invoice, but in this screenshot we can see that there are several.

Hope you can help me,

Regards,

Tom Victor

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Chris-D 1,246 on at

Like (0)

Report
Copy link

Link copied!

Hi @TomVictor, I don't understand from the screenshot where this is failing? I see the list of services, I can't see where you're having a problem displaying the invoices?

Without seeing your data, what I would do here is have a column in the Invoice table called Service_ID, which stores the ID number of the service it's linked to.

Then when you need to recall the invoice, you'd look up the invoice where Service_ID = ThisItem.ID in your service list gallery.

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chris-D

On the right side, I have a scroll bar with many invoices displayed and I only need one.

I will try your idea, I think it's a good one

Was this reply helpful? Yes No
Akash1ve 112 on at

Like (0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
Verified answer

Chris-D 1,246 on at

Like (0)

Report
Copy link

Link copied!

ok I see the scrollbar.

Yes, linking the invoices with the service ID is the only way to do this really. If there is a chance your 3 columns, Client, Commande and Prestation will not be unique then you would always have the possibility of multiple results.

The other way, if there is always only one invoice with each service, is just to include the columns from the invoice table with the service table?

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

I tried your idea @Chris-D and you are right it's the only way to do this.

Now I have another issue, I can't get other service ID. I don't know why but I only get one of them and the rest is in the void.

I send another screenshot for this issue

It's the same name and I can't get the ID of the down one.

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure what you mean here. I don't recognise that as an ID field, is it a GUID?

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

Yes it's a GUID and not an ID, I'm not sure if dataverse have another ID than the GUID

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (0)

Report
Copy link

Link copied!

Ohh ok. I've not done much with Dataverse yet, I work mainly with SP lists, so I'm not sure how it would work in DV. Maybe you need a different column type or something.

Maybe ask this as a different question for that issue.

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

Sure thanks for your help !

Was this reply helpful? Yes No