Custom search on PowerApps portals

(0) Share

Report

Posted on by MartinVargas

312

Hi Community,

I am having the following problem: At the time of injection in the URL “?value=1-001 DOLARES”, it is not showing me any data.

This is the schema of my table:

And this is my Custom Javascript;

{% fetchxml articles %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
 <entity name="crd4f_articles">
 <attribute name="crd4f_elementslistspricieid"/>
 <attribute name="crd4f_idelement"/>
<attribute name="crd4f_ idlistprice"/>
 <attribute name="crd4f_description"/>
<attribute name="crd4f_price"/>
 <filter type="and">
 <condition attribute="crd4f_ idlistprice" operator="eq" value="{{request.params['value']}}" />
 </filter>
 </entity>
</fetch>
{% endfetchxml %}
{% if articles.results.entities.size > 0 %}{
 "results":
 [
 {% for article in articles.results.entities %}
 {
 "Id": "{{article.crd4f_elementslistspricieid}}",
 "Element": "{{article.crd4f_idelement}}",
 "Description": "{{article.crd4f_description}}"
 }
 {% unless forloop.last %},{% endunless %}
 {% endfor %}
 ]
}
{% else %}
 No data found.
{% endif %}

It should be noted that this table has more than 20,000 records.

Can you help me here?

I would appreciate it Guys.

Categories:

Power Apps portals

I have the same question (0)

All responses (19)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report
@MartinVargas

Try to do as below to get the pricelistid

{% assign pricelist = request.params.value %}

and in the fetch:

{% fetchxml articles %} <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" > <entity name="crd4f_articles"> <attribute name="crd4f_elementslistspricieid"/> <attribute name="crd4f_idelement"/> <attribute name="crd4f_ idlistprice"/> <attribute name="crd4f_description"/> <attribute name="crd4f_price"/> <filter type="and"> <condition attribute="crd4f_ idlistprice" operator="eq" value="{{pricelist}}" /> </filter> </entity> </fetch> {% endfetchxml %}

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Hi @Mira_Ghaly. Try to do it as you mention. I just don't know if I implement it the right way.

This is part of the fetchxml:

{% fetchxml articles %} {% assign pricelist = request.params.value %} <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" > <entity name="crd4f_articles"> <attribute name="crd4f_elementslistspricieid"/> <attribute name="crd4f_idelement"/> <attribute name="crd4f_ idlistprice"/> <attribute name="crd4f_description"/> <attribute name="crd4f_price"/> <filter type="and"> <condition attribute="crd4f_ idlistprice" operator="eq" value="{{pricelist}}" /> </filter> </entity> </fetch>

When testing it I get the following error:

Can you tell me what I'm doing wrong?
Regards.

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report
Hi,

In the URL you still need to pass parameter as value only (?value=1-001 DOLARES) and also define assign variable outside fetchxml

{% assign pricelist = request.params.value %}
{% fetchxml articles %} <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" > <entity name="crd4f_articles"> <attribute name="crd4f_elementslistspricieid"/> <attribute name="crd4f_idelement"/> <attribute name="crd4f_ idlistprice"/> <attribute name="crd4f_description"/> <attribute name="crd4f_price"/> <filter type="and"> <condition attribute="crd4f_ idlistprice" operator="eq" value="{{pricelist}}" /> </filter> </entity> </fetch> {% endfetchxml %}
Also make sure, the data is available for the given value (1-001 DOLARES)

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report
Hi @MartinVargas

Just replace value with the name in your query string

{% assign pricelist = request.params.pricelist %}

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Hi @Mira_Ghaly and @Soundharya , the fetch code and query look like this:

{% fetchxml articles %} <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" > <entity name="crd4f_articles"> <attribute name="crd4f_elementslistspricieid"/> <attribute name="crd4f_idelement"/> <attribute name="crd4f_ idlistprice"/> <attribute name="crd4f_description"/> <attribute name="crd4f_price"/> <filter type="and"> <condition attribute="crd4f_ idlistprice" operator="eq" value="{{pricelist}}" /> </filter> </entity> </fetch> {% endfetchxml %} {% if articles.results.entities.size > 0 %}{ {% assign pricelist = request.params.pricelist %} "results": [ { "Id": "{{pricelist.crd4f_elementslistspricieid}}", "Element": "{{pricelist.crd4f_idelement}}", "Description": "{{pricelist.crd4f_description}}" } {% unless forloop.last %},{% endunless %} {% endfor %} ] } {% else %} No data found. {% endif %}

While testing this fetch, it still doesn't show me data:

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@MartinVargas

I am confused from screenshots sometimes the query url has Value and sometimes has pricelist which one you are using?

So which one you are using and which one do you use in the assign?

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report

@Mira_Ghaly
As @Soundharya showed me, I try to display the data with the value (?Value=1-001 DOLLARS). That is why I did that test.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report
@MartinVargas

I want to check if you had added Table permissions to the entity

crd4f_articles

Can you please check that?

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report

@Mira_Ghaly , sure!

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@MartinVargas

I have noticed something in your fetch please move this step at the top and try again

And make sure the url has the query string parameter as pricelist.

Was this reply helpful? Yes No