How to use FetchXML in Microsoft Power Pages using Liquid Code?

This video demonstrates how to use fetch XML using Liquid code in Microsoft Power Pages to query the backend Dataverse tables.
Girish Uppal walks you through the steps of querying the backend tables using FetchXML query embedded using Liquid Code
{% fetchxml %} {% endfetchxml %} tags are used to execute fetch XML blocks that retrieves backend data from dataverse tables.
#microsoft #microsoftpowerplatform #powerplatform #powerpages #dataverse #liquid #powerapps #powerappsportals
✔️View other useful contents in the playlist:
• Centre of Excellence K...
• Power Apps
• Power Pages
• Microsoft Edge
• Power Platform
• D365 Customer Service ...
• D365 Customer Service
• Tools / Utilities
• Microsoft Copilot
✔️You can visit girishuppal.com (Girish Uppal) website to get more productivity tips.
✔️Please subscribe to @powertechspeck RUclips channel / @powertechspeck to get more productivity tips and tutorial content from Girish Uppal
✔️You can view my LinkedIn Profile at: / girishuppal
✔️You can view the badges earned by me at: www.credly.com...

[@mjpworks9367]

I have followed the exact steps outlined in the provided video to create a query that should return 5 rows based on specific conditions. I am encountering an issue with a FetchXML query that is supposed to return 5 rows. The row count is fluctuating unexpectedly, sometimes returning 1 or 7 rows instead. I have tried creating a new FetchXML code but the problem persists. I am seeking assistance to understand the reason behind this inconsistent behavior.

[@PowerTechSpeck]

Strange - Can you share your code ?

[@barnaliroy8703]

How to write complex queries like JOIN or use wildcards like "%" in FetchXML and use that in Liquid code? because Liquid code syntax already uses "%".

[@PowerTechSpeck]

Hi Barnali - I will try to run some series on Liquid and FetchXML soon. Thanks.

[@michaeljata4117]

Thanks for sharing. Did you try using a FetchXML query with linked entity and link type "not any"?

[@PowerTechSpeck]

Not yet Michael

[@MohdYasen]

I am trying to handle the incoming XML data via form POST and display it on the Power Pages, I tried to parse the XML and then dynamically update the content but didn't work. We cannot use FetchXML for this purpose since FetchXML is specific to querying Dataverse data and not handling form POST data.
Do you have any suggestions?

[@PowerTechSpeck]

Hey Mohd, You can use Power Automate to parse POST response and utilise in Microsoft Power Pages site. For Power Pages and Power Automate integration, please refer to this video: ruclips.net/video/oNlqiIz1w_I/видео.html

[@KwikInsights]

That was great, could you do a video on how to make the value = "%AIR%" dynamic and based on logged in user not fixed value but based on liquid tag being user.fullname equalling a column for example assigned to

[@PowerTechSpeck]

Hi KwikInsights, Do you need a liquid code solution or OData Syntax or FetchXML equivalent ?

[@PowerTechSpeck]

Also, Can you explain me the use case please ?

[@vinitajain1692]

How to manage navigation menu based on contact type

[@PowerTechSpeck]

Hi Vinita - Can you please elaborate your query ? Do you mean user with different security roles ?

[@vinitajain1692]

@@PowerTechSpeck In contact table we have a column which can be true or false. Possible we can show hide navigation menu based on that column value.