Answered

How to filter GUID Price List

(0) Share

Report

Posted on by jdaniel1

I am pulling my hair out to why this isn't working. For some reason GUID are just a pain in the a## with Dataverse. I'm about to code a Power Automate that just stores the GUID in its own Text field.

I have a gallery. I am trying to do a normal Filter.

LookUp('Price List Items', "pricelevelid" = lbl_QuoteIDVar.Text )

* I know this price list exist. I specifically debug it to a specific record. I've tried 'Price List', i've tried 'pricelevelid', i've tried wrapping into a GUID() statement. Almost all the time i get an error. The above code it finally doesn't error but it doesn't show any resuilts ether.

Table Name is: Price List Item

Field, I want to filter is Price List (pricelevelid)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Hi @jdaniel_dyn365

Try this:
LookUp('Price List Items', XXXXX_pricelevelid = GUID(lbl_QuoteIDVar.Text)) // Please replace XXXXX with your DataVerse prefix

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
Datanerd 103 on at

Like (0)

Report
Hello ,

Please try a filter instead as below

Filter('Price List Items', prefix_pricelevelid = GUID(lbl_QuoteIDVar.Text) )

Was this reply helpful? Yes No
jdaniel1 83 on at

Like (0)

Report

@Datanerd @AARON_C There is no Prefix, this is a system field, not a custom field like new_field.?

Was this reply helpful? Yes No
Verified answer

jdaniel1 83 on at

Like (0)

Report
Ugh so I forgot to do a extension to the 'Price List'. And wrapping it in a GUID() helped as well.

LookUp('Price List Items', 'Price List'.'Price List' = GUID( dcard_DefaultPriceList.Selected.'Price List' ) )

Was this reply helpful? Yes No