cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How to Update CDS Entity Record using Values from FormProcessor

Dear All,

I have embedded a Canvas App into a Model Driven App form (Contact). The canvas app has AI builder form processor. I've trained my model and i'm able to read the data as well.

 

The query is, how do i update the same data on a particular record which i've opened in Model Driven form.

 

E.g. I've Opened a contact record with ID C0001 in model driven. In a seperate tab i've uploaded a document which gave me values for certains feilds. Now i have to update the record with ID C0001 with the retrieved values.

 

Regards,

 

 

4 REPLIES 4
Super User
Super User

Hi @niteshdambale 

 

I haven't done this before but I would imagine that you would use the SaveForm action from the ModelDrivenFormIntegration control on your embedded Canvas app.  The (light) documentation is here https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embedded-canvas-app-properties-ac...

 

I'm also interested in this so let me know if you try this and it works.

Hi @HSheild,

 

Thanks for your response. I didnt use Saveform, however could manage to update the record using patch function. What i was as follows :

 

1) Onchange event of Formprocessor used updatecontext to set variable value against each field avialable on my form

2) I then did set the "Default" property of each field to variable. (This gave me all new values as and when i upload a PDF)

3) Used a Custom button. On Select property of the custom button used patch function. My function first filtered the record using ID field which is a primary field and which i've set as autonumber..

Sample Function: Patch(Contacts,First(Filter( Contacts, ID = DataCardValue2.Text ) ), { 'Address 1: City' : DataCardValue4.Text } )

 

Just to elaborate :

a) "Contacts" = CDS entity
b) "ID" is an attribute in the "Contacts" Entity (Primary field)
c) "DataCardValue2.Text" is the value on form processor Card
d) "Address 1 : City" is the parent.display name of the field on form processor
e) DataCardValue4.Text is the value captured on form processor and intended to be updated in CDS entity record.

 

Further just want one help with respect to point no 2 which i've mentioned above. In case my form consist of Lookup and OptionSet, I am not able to set the default variable value to the fields, as i have "text" value and the field type is Optionset or Lookup.

 

Regards.


@HSheild wrote:

Hi @niteshdambale 

 

I haven't done this before but I would imagine that you would use the SaveForm action from the ModelDrivenFormIntegration control on your embedded Canvas app.  The (light) documentation is here https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embedded-canvas-app-properties-ac...

 

I'm also interested in this so let me know if you try this and it works.



@HSheild wrote:

Hi @niteshdambale 

 

I haven't done this before but I would imagine that you would use the SaveForm action from the ModelDrivenFormIntegration control on your embedded Canvas app.  The (light) documentation is here https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embedded-canvas-app-properties-ac...

 

I'm also interested in this so let me know if you try this and it works.


 

Agree with @HSheild. A possible approach is that with ModelDrivenFormIntegration  you can retreive the contract record id, and use the CDS connector in the canvas app to save the results. 

Hi @JoeF-MSFT ,

 

I've sucessfully updated the record using patch function. example : Patch(Contacts,First(Filter( Contacts, ID = DataCardValue2.Text ) ), { 'Address 1: City' : DataCardValue4.Text } )

 

Where :

 

a) "Contacts" is CDS entity
b) "ID" is an attribute in the "Contacts" Entity.
c) "DataCardValue2.Text" is the value on form processor Card (This is my record identifier)
d) "Address 1 : City" is the parent.display name of the field on form processor
e) DataCardValue4.Text is the value captured on form processor and intended to be updated in CDS entity record

 

Regards.

 

 

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Users online (7,995)