Answered

To read the choice field value of Finance and operations virtual entity

(0) Share

Report

Posted on by Ajay kumar Pollamsetty

Hi All,

I have Finance and operations virtual entity from which I need to check for a field value and do some validation in portal.

In F&O, the field is a checkbox field. So this becomes like a choice field in Dataverse table with choices NO and YES.

While browsing the virtual table record in SQL 4 CDS, I can see the field holds integer values like, for YES - 200000001 and for NO - 200000000.

But I cannot compare the same field value with these integer values in portal. I get empty/blank values from the field.

I am able to do update the same field with these integer values using portal webapi. This works.

Only reading the choice field value is the problem.

Any help? Thank in-advance

Categories:

Power Apps portals

I have the same question (0)

All responses (7)

Answers (1)

Sort by

H V 1,510 on at

Like (0)

Report
Copy link

Link copied!

Hi @sumadhuram456

Can you please share screenshots of your field in Portal and also screenshots of Inspect Element of that fields?

Was this reply helpful? Yes No
Ajay kumar Pollamsetty 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @hardikv
I am using a custom web template and this field is not displayed on the page.
I get the record from fetch xml, and reading the field value to evaluate a condition.

Below, claimline.mserp_validforresubmit is the NoYes choice field of the virtual entity.
variable 'allowEdit' always evaluates to false irrespective of the field value
I tried with 200000001, "Yes", true, 1. Nothing works.
I tried to display the field value on the page. Its value is never shown.

Was this reply helpful? Yes No
H V 1,510 on at

Like (0)

Report
Copy link

Link copied!

Hi @sumadhuram456
Please check that your field is available in your fetchxml.

<attribute name="mserp_validforresubmit" />

--------------------------
If you like this post, give a Thumbs up. Where it solved your query, Mark as a Solution so it can help other people!

Was this reply helpful? Yes No
Ajay kumar Pollamsetty 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @hardikv

This field exists in fetchxml

Was this reply helpful? Yes No
Verified answer

H V 1,510 on at

Like (0)

Report
Copy link

Link copied!
Hi @sumadhuram456

In choice field, you have to use value and label in liquid template.

{{ claimline.mserp_validforresubmit.value }} {{ claimline.mserp_validforresubmit.label }}

claimline.mserp_validforresubmit.value --> 200000001
claimline.mserp_validforresubmit.label --> YES

--------------------------
If you like this post, give a Thumbs up. Where it solved your query, Mark as a Solution so it can help other people!

Was this reply helpful? Yes No
Ajay kumar Pollamsetty 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you @hardikv . It works 😊

Was this reply helpful? Yes No
H V 1,510 on at

Like (0)

Report
Copy link

Link copied!

Hi @sumadhuram456

Glad to hear that your issue has been resolved.

Was this reply helpful? Yes No