Fetchxml with dynamic value without json

[CoSonate1]

My requirement is to get all the details of an entity on the second page when I click on the email button on first page. I have tried -

1. if else condition in liquid code but was not able to fetch user input in liquid

2. in the for loop I was getting all the email ids to compare with the user input email id.

I have used fetchxml to only get the data

{% fetchxml inprogress_query %}

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

      <entity name="cr2d2_edueventattendee">

        <attribute name="cr2d2_edueventattendeeid" />

        <attribute name="cr2d2_firstname" />

   <attribute name="cr2d2_lastname" />

<order attribute="cr2d2_firstname" descending="false" />

        <filter type="and">

          <condition attribute="cr2d2_email" operator="eq" value="{{}}" />

        </filter>

      </entity>

    </fetch>

 What should i pass inside value to get the single email record that user has entered and match it with data verse to display details on second page?

[Lucas001]

Hi @CoSonate1,

liquid is execute on the server side so you won't be able to run it properly when somebody chooses or enters something in  textfield etc.

The approach usually is to create a blank page, use the liquid to fetch all inside a JSON and than use a fetch JSON function to get all needed info.

--------------------------------------------------------------------------------------

Hope that helps.

If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

[CoSonate1]

 I have changed my code to this and it is still not working. I have added the site settings and even enabled the table and column permissions but I am getting results as blank, I have added this code in a web template

  {% assign email = request.params['email'] %}

   {% fetchxml inprogress_query%}

    <fetchversion="1.0"output-format="xml-platform"mapping="logical"distinct="false"count="1">

      <entityname="cr2d2_edueventattendee">

         <attributename="email"/>

        <orderattribute="name"descending="false"/>

        <filtertype="and">

         <conditionattribute="email"operator="eq"value="{{email | xml_escape}}"/>  

        </filter>

      </entity>

    </fetch>

    {% endfetchxml %}

    {

"results": [

{% for result in inprogress_query.results.entities %}

"{{ result.edueventattendeeid | escape }}

{{ result.email }}

"{% unless forloop.last %},{% endunless %}

{% endfor %}

]}

      <script>

          $("#searchtbutton").click(function () {

$.ajax(

  method: 'GET',

  dataType: 'json',

  url: "/details?Email=" + encodeURIComponent(myEmailVariableHere)

}).done(function(data) {

  console.log("I found " + data.results.length + " result(s)");

});

}); 

      </script>

With reference to -https://powerusers.microsoft.com/t5/Power-Apps-Portals/How-to-execute-FetchXML-query-on-button-click...

[Fubar]

what happens if you hardcode the email address in the query? (if still no results, run the query from XrmToolBox to see if you get any results there)

[CoSonate1]

I can now fetch values from power portal webapi ,but one of my code is not working with webapi

success: function (res) {

        console.log(res);

                window.location = "https:/contoso.powerappsportals.com/details/?id="+res.value[0]. crd2_id;

        },

        fail: function () {

          console.log();

          alert("Doesnt work");

          }

I dont get the alert message. Can anyone help me with it.