In this Power Automate tutorial, We will discuss an error i.e. Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’ while working with Datavesre and as well as its solution.
When I was working with Dataverse recently, I needed to use Power Automate to upload a file or an image into a Dataverse row.
For this, I have used a Dataverse List Rows action to filter the rows, and the below error occurred “Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’“.
Refer to the screenshot below that how the error displays in the flow:
We’ll now go into more depth about this issue and how to fix it.
Also, Read: Invalid Connection. Please Choose a Connection Power Automate
Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’ – Error
- I have a Dataverse table named IT Issue Resolutions. In this table, I have various columns like Issues, Report Date, Attachments, etc with different data types. Along with them, there is a Dataverse Primary column named Sender.
- Also, this Dataverse table has some records as shown in the screenshot below:
- Now, I would like to upload a file or an image into a specific Dataverse row using Power Automate.
- In order to do this, I filtered the rows using a Dataverse List rows action, and if the value matches, then the particular file or image will upload in that particular dataverse row.
- In the Dataverse List rows action, there is a field called Filter rows. And I filtered the Sender name i.e.
contains(crf9a_Sender, 'From')
- This means if the sender’s name contains any value from the When a new email arrives (V3) (From), then the flow will proceed and execute.
- While I used the above code in the Filter rows field, I got an error like “Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’“.
NOTE:
Even if you will try the code like contains(Sender, ‘From’), then also you will get the same error like “Could not find a property named ‘Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’“.
- The error clearly states that the fields like it cannot able to recognize the property or column name i.e. ‘crf9a_Sender’ from the Dataverse table (IT Issue Resolutions).
Now we’ll look at how to resolve the abovementioned Power Automate problem in the part that follows.
Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’ – Solution
When I ran across this Power Automate issue, I did some research online and browsed a number of websites. Here, I integrated it into the code which eventually resolved my problem and carried on as necessary. Follow the instructions below:
- Go to the Dataverse table (IT Issue Resolutions) -> Expand Sender column -> Click on Edit column -> Expand Advanced options -> Copy the Logical name i.e. crf9a_sender as shown in the image below.
- Now go back to the existing flow, expand the List rows action, and paste that Sender logical name (crf9a_sender) inside the contains function that looks like below:
contains(crf9a_sender, 'From')
Refer to the image below.
- Once the flow is ready, just save and test the flow. Now you can see the flow will execute without giving any error.
This is how we can resolve the Power Automate issue i.e. “Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’” while working with Dataverse table.
Furthermore, you may like some more Power Automate and Dataverse tutorials:
- Power Automate Dataverse Upload a File or an Image
- Power Automate Dataverse Update Multiple Rows
- Unable to process template language expressions in action Power Automate
- How to format a currency column in Power Apps?
- How to Patch Dataverse Choice Column in Power Apps
- Power Apps Get Value Of Choice Field Dataverse
- How To Get Dataverse List Rows Count Using Power Automate
In this Power Automate tutorial, We discussed an error i.e. Could not find a property named ‘crf9a_Sender’ on type ‘Microsoft.Dynamics.CRM.crf9a_itissueresolutions’ while working with Datavesre and its solution.
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.