PowerPlatform – Page 6 – Nishant Rana's Weblog

How to – Handle single quote/apostrophe in Filter Rows in Power Automate (Dataverse)

Say for e.g. we have the below flow, which finds the lead having subject as “My Test’s Value”

On running it we get the below error

To make it work we can make use of replace function here.

replace(variables('Subject'),'''','''''')

‘ = to espace

‘ = special character

replace(variables(‘Subject’),‘‘‘‘,‘‘‘‘‘‘)

Please refer to the helpful post- https://techcommunity.microsoft.com/t5/power-apps-power-automate/how-to-handle-single-quotes-in-the-filter-property-with-get/m-p/2617747

This time it works successfully.

ChatGPT – quick to correct and give the right answer.

Hope it helps..

Advertisements

Format property missing in Date Picker in custom page – Dataverse / PowerApps

Recently while designing the custom page, we realized that the format property is missing for the Date Picker control. This is because Date Picker control is based on Fluent UI Library.

One option earlier was to enable the Classic Controls from Settings

And replace the existing control with the classic control

Also, check – https://debajmecrm.com/get-todays-date-format-dates-in-power-apps-canvas-app/

https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-picker-missing-format-property/td-p/903794

https://powerusers.microsoft.com/t5/Building-Power-Apps/Custom-Page-Date-Picket-Format-Date/td-p/1349351

Hope it helps..

Advertisements

Fixed – Value must be a data entity record error in Power Apps

We got the below error while trying to use the Relate function – “Value must be a data entity record”

As the error message clearly states and also if we see the syntax, the Relate function expects a record

Below was our formula for OnSelect, which was throwing the error

Here instead of passing the record, we were passing the table in the Relationship which was the reason for the error.

We changed it to store the ThisItem

And also updated the OnSelect

This fixed the issue for us.

Hope this helps..

Advertisements

Fixed – Custom Page not opening or Page doesn’t exist in this app error in the model-driven app (PowerApps)

Recently we created a custom page to be opened from the Ribbon / Command bar, however, the page was not opening for us, even though the function was running properly.

https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/navigate-to-custom-page-examples

Here we had created the custom page from within the solution area, so we need to add this custom page to our model-driven app. (The other option is to create the page from the Modern App Designer.)

https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/add-page-to-model-app#create-or-edit-a-custom-page

Open the app in the Modern App Designer and click on Add Page

Select Use an exiting custom page, select the page and uncheck the Show in navigation option as we are opening this page from the form.

Publish the app.

This time clicking on Open Custom page command/button on the form successfully opened the custom page for us.

Thanks to Andrew (https://butenko.pro/) for the solution.

Hope it helps..

Advertisements

Fix- Multiple levels of many-to-one relationship expansion aren’t supported in PowerApps

We would get this error while trying to get the value of a related entity (lookup) through a related entity (lookup) in the current record using the incorrect formula.

For e.g. here Region is a lookup in the Village, which in turn is a lookup in the Product record (ThisItem).

The solution here is to use the LookUp function

Before	After
ThisItem.Village.Region.Name	LookUp(Villages, Village = ThisItem.Village.Village).Region.Name
	Search the Villages table, using the GUID of the Village, and fetch the name of the region lookup field in it.