You’re offline. This is a read only version of the page.
425
Hi,
I am sending an email using ms flow, In this flow I am using the fetch xml(list record) to get the link entity attribute and I want to check the null condition on link entity attribute.
As I have applied this expression "items('Apply_to_each')?['emailaddress1'] is not equal null" it's giving false result while this emailaddress1 field contains the valid email address.
Fetch:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="invoice">
<attribute name="invoiceid" />
<attribute name="cyno_preparationofinvoicedate" />
<attribute name="cyno_invoiceduedate" />
<link-entity name="cyno_audits" from="cyno_auditsid" to="cyno_audits" link-type="inner" alias="aa">
<attribute name="cyno_auditfile" />
<link-entity name="cyno_lease" from="cyno_leaseid" to="cyno_leasefile" link-type="inner" alias="lease">
<attribute name="cyno_leasenumber" />
<attribute name="cyno_clientinternal" />
<attribute name="cyno_ctspm" />
<attribute name="cyno_ctsauditor" />
<link-entity name="account" from="accountid" to="cyno_account" link-type="inner" alias="account">
<link-entity name="contact" from="parentcustomerid" to="accountid" link-type="inner" alias="contact">
<attribute name="fullname" />
<attribute name="emailaddress1" />
<filter type="and">
<condition attribute="cyno_invoicingcontact" operator="eq" value="1" />
</filter>
</link-entity>
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>
Hi,
Thank you for your query.
Linked Entity attributes are accessed using an alias.
In your example, try with contact.emailaddress1.
It would be easier for you to read/debug the body of the output of the list action to understand how the result is stored.
Share
Report
All responses (
Answers (
