Answered

How to set entity value using liquid

(0) Share

Report

Posted on by Dhananjay_Patil

175

Hello,

How to set back updated value for any field (CDS entity) ?

I am trying following liquid code but failed to set value

 {% assign account = entities.cr305_vendors['8d0b431e-97c6-ea11-bf21-0003ff906c75'] %}
{% if account.cr305_vendor_name == 'sample name' %}
 {% assign account.cr305_password = 'abc1234' %}
{% endif %}

Categories:

Power Apps portals

I have the same question (0)

All responses (10)

Answers (2)

H V 1,510 on at

Like (0)

Report
Copy link

Link copied!

Hi @Dhananjay_Patil
You can not update a field using liquid code in PowerApps Portal.

entities: Allows you to load any Power Apps entity by ID
MS Doc: https://docs.microsoft.com/en-us/powerapps/maker/portals/liquid/liquid-objects#entities

Was this reply helpful? Yes No
Dhananjay_Patil 175 on at

Like (0)

Report
Copy link

Link copied!

@hardikv

any other options to set entity value using code?

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

Like (0)

Report
Copy link

Link copied!

Hi @Dhananjay_Patil
Yes, you can update field using power automate.
You need to create a HTTP TRIGGER power auto mate as per this doc and pass the password field value in JSON format.

In power automate, you can get password field and update in your entity.
-------------
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
Dhananjay_Patil 175 on at

Like (0)

Report
Copy link

Link copied!

@hardikv

can I implements functionalities with reference to below link?

https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-http-requests-handle-errors#http-methods

https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-perform-operations#web-api-ajax-samples

Was this reply helpful? Yes No
Verified answer

H V 1,510 on at

Like (1)

Report
Copy link

Link copied!

Hi @Dhananjay_Patil
Yes you can implement that functionality.

webapi.safeAjax({
type: "PATCH",
url: "/_api/accounts(00000000-0000-0000-0000-000000000001)",
contentType: "application/json",
data: JSON.stringify({
"name": "Sample Account - Updated"
}),
success: function (res) {
console.log(res);
}
});

You have to also add Wrapper AJAX function for CSRF token code from the given link.

Was this reply helpful? Yes No
Verified answer

oliver.rodrigues 9,425 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

first make sure your portal has the early upgrade option checked
webapi is only available if your portals is on version 9.2.6.41 +

you can check the version in the clear cache page as well

------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Dhananjay_Patil 175 on at

Like (0)

Report
Copy link

Link copied!

@hardikv

I am trying with same code from below link

https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-perform-operations

but getting Web API not found error everytime , Error Code: 404

I already tried all settings from given linked

Was this reply helpful? Yes No
oliver.rodrigues 9,425 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Dhananjay_Patil did you check your portal version?

Was this reply helpful? Yes No
Dhananjay_Patil 175 on at

Like (0)

Report
Copy link

Link copied!

@OliverRodrigues

Yes I checked , unfortunately its 9.2.5.15

But when I create new portal be default its version is 9.2.5.15 and when my team member created portal he got version 9.2.6.58

How to create portal with latest version i.e. 9.2.6.58?

Was this reply helpful? Yes No
oliver.rodrigues 9,425 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Dhananjay_Patil you need to enable Portal for early upgrade: https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/upgrade-portal

but it might still take a few days/even a week for the Portal to be updated

also note that Web API is still under preview, we don't know if it will change or anything, so be careful if using in Live environment

Was this reply helpful? Yes No