Current Value from Dataverse Table in Cavas App

[MrsAndrus]

I would like to create a Cnvas App and bring the Values form the Dataverse Table to it.

With the functions as First, Last, Index etc. I can get the exact Datarecord. 

Can I get the current record. I mean if I add my canvas app to the form and show the value from the current record (current Form).

Would be grateful for help.

Thank you!

[Amik]

@MrsAndrus - I do not understand your terminology. Could you please elaborate more on what you mean by "current record" ?

[MrsAndrus]

@Amik Thank you for the responce! I've dared to make a schema, hope it will help me to explain, what I mean.

I have a Table (ex. Books) and for this table there are several Data Records (1, 2, 3). 

When I open the Form for the Record, I would like to see the values from the exact Record by mens of canvas as webresource.

Thank you!

[Amik]

@MrsAndrus - sorry but I am still confused by your terminology. A "web resource" is a file which is stored in Dataverse.

[MrsAndrus]

@Amik Sorry for the delay with the responce. I still can't resolve my problem. Would be grateful for the help and I will try to explain, what is not clear for me, how to implement.

1. I've created a Canvas App and Added it to the form in model diven app.

2. At canvas app it is assumed, that the data form the fields at the form (where I've added the canvas) will be shown at cancas app.

Unfortunately I can make, that only the last input data from fields will be displyed, no matter of the data record.

I mean I have a Project Table. At the Form for the table it is a Canvas app component.

I've created a new Product (Data record) - Product 1 and I would like the Data from the form will be displayed at canvas app.

When I create one more Product - Product 2 - I would like the Data from the from for Product 2 will be displayed at the appropriate canvas app at the form.

But now with the 'First' function in canvas the last input data (ex. for Product 2)  will be displayed in Product 1 as well, but not the data for Product 1 at the form for Product 1 at the appropriate canvas and the same for the Product 2.

Would be grateful for the advice. Thank you!

[AndrewR1]

Hi @MrsAndrus  dose your canvas app have the following in the tree view: 

Using this:

[@ModelDrivenFormIntegration].Item.yourfiled you can then filter the Dataverse list to show the current items records. 

My example: 

If you don’t have this ModelDrivenFormIntegration in your canvas app you will need to create the app again inside the model driven form to enable this in the canvas app. 

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[MrsAndrus]

Hi @AndrewR1! Thank you for the reply! 

Unfortunately I have no ModelDrivenFormIntegration option in canvas app.

I would be grateful if you can shortly guide me, what do you mean with the "create the app again inside the model driven app". 

My steps to create a canvas app - is to create the app and then add as a component. Vise Versa I failed as there was no canvas app created. Would be grateful, if you cann corret me in my reasoning. Thank you!

[AndrewR1]

Hi @MrsAndrus  that will definitely be your issue then you can follow the MS Documentation on how to add a canvas app to a model driven form:
Add the app:
https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/embedded-canvas-app-add-classic... 

Edit the app:
https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/embedded-canvas-app-edit-classi... 

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew