cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User II
Super User II

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.

Highlighted

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.


 

Highlighted

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. 

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (8,998)