Canvas Apps – Nishant Rana's Weblog

Field suggestions by Copilot –Power Apps (Dataverse)

Field Suggestions by Copilot for Canvas Apps apply to Gallery, Form Table controls both classic and modern for Dataverse, SharePoint, or SQL Server data source. It analyzes the schema of the table selected and recommends up to 10 fields that also include a maximum of 10 required fields of that table.

Let us see it in action.

Below we have the following fields defined as required fields in the lead table.

A screenshot of a computer

Description automatically generated

Now inside CanvasApp when we insert and bind the Modern Form / Table or the classic Edit Form / Display Form, Data Table to the lead table it automatically suggests the fields for binding.

Here we have selected Lead as the Data Source for the Edit form or Form (modern) control.

Here we can see it suggesting all the required fields of the lead along with other key fields of lead like City, Country, Email, First Name, etc.

In the case of Table, we can see it suggesting the following 10 fields.

In the case of a custom table with very few fields in it, it suggested the below fields for Form and Table control.

Get all the details here.

Hope it helps..

Advertisements

Analyzing PowerApps Canvas and Model-Driven Apps Performance

Analyzing PowerApps Canvas and Model-Driven Apps Performance

Using Customer Lookup in Canvas Apps (Dataverse)

For this example, we are taking the Company Name customer lookup column of the contact table.

We start by adding the Customer Name field to the form.

That adds a card to the form, let us add the required controls to get it working

Radio Button, Combo box, and Text Label for the combo box.

Change the Items property of the radio button to show the contact and account option.

Also, change the Layout to Horizontal and Default as Contact.

And set the Items property of the Combo box as below –

Based on the value selected in the radio button, we are setting the Data Source and also applying the Sort and Distinct function to it, along with StartsWith for delegation.

We have also set Allow searching as On for the combo box.

For the Contact option selected –

For the Account option selected –

Also, we can set the OnChange property of the radio button to Reset(comboControl) to clear the selection when the user switches between Contact and Account options.

Now to have this value saved back we can specify the Update property of the custom data card in which we have placed these controls.

References –

https://www.youtube.com/watch?v=y-VvNDwy_Jw&t=1191s

https://debajmecrm.com/configure-customer-lookup-to-show-either-contacts-or-accounts-in-canvas-apps/

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-references#show-the-columns-of-a-customer

Hope it helps..

Advertisements

Fixed – Canvas App / Custom Page not showing data (Dataverse / PowerApps)

Recently we faced an issue wherein the custom page was not loading any data, however, it was working for users with the System Administrator role.

The gallery control shows the Product details.

There were no errors in the Developer Tools, we tried by giving all Organization level rights to the users on the tables involved etc. but that didn’t help.

Eventually, it all came down to this particular line in the formula used for the Items property of the Gallery Control i.e. Asset Status field (custom field).

We had a field security profile created which had Read set as No and the users were part of that security profile, which explained why it was only working for System Admin users.

Changing the Read access to Yes for that column fixed the issue for us.

Hope it helps..

Advertisements

How to set Date Picker as Blank (Null)- Canvas Apps / Dataverse

If no dates are selected the Date Picker control will display a default date.

This comes from the InputTextPlaceholder property

We can update the formula to set the field as blank.

If(IsBlank(Self.SelectedDate), Text(Blank()))

Hope it helps..

Advertisements

Error when trying to retrieve data from the network – Power Apps/ Dataverse

Recently in one of the custom pages (canvas app), we started getting the below error “Error when trying to retrieve data from the network” and no data was being retrieved.

Decreasing the data row limit to 500 from 2000 seemed to fix this issue for us.

I assume it could be because of the number of records increasing in the environment over time causing this issue.

Interestingly after a few days when we tried to check the root cause of the issue, by increasing the row limit back to 2000, we weren’t getting that error anymore.

Articles to refer –

https://thepoweraddict.com/how-to-fix-error-when-trying-to-retrieve-data-from-the-network/

https://powerusers.microsoft.com/t5/Building-Power-Apps/quot-Error-when-trying-to-retrieve-data-from-the-network-quot-on/td-p/1452970#:~:text=This%20may%20be%20a%20temporary,connection%20to%20test%20it%20again.

https://sharepains.com/2022/07/04/error-when-trying-to-retrieve-data-from-the-network/

Hope it helps..

Advertisements