cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
soumyadeep2201
Frequent Visitor

Unable to filter dataverse table with column where data type as autonumber

Hi Experts,

 

I have a dataverse table where Primary Column set as Autonumber like below

soumyadeep2201_0-1664517919862.png

 

Now I am trying to use List Rows Action In Power Automate by putting filter like below

 

soumyadeep2201_1-1664518070244.png

 

but its failing saying "Could not find a property named 'B0001006' on type 'Microsoft.Dynamics.CRM.crb05_{tableName}'." where B0001006 is the value.

 

Can you please help me on this. Is it if I set Primary column as Autonumber with custom formatting, dataverse will not allow to filter like this. Looking for your valuable inputs.

 

Regards,

Soumyadeep

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@soumyadeep2201 

Can you please try to put the barcode between single quotes and give it a try?

I don't believe there is a limitation for filtering by autonumber column.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User
Dual Super User

@soumyadeep2201 

Can you please try to put the barcode between single quotes and give it a try?

I don't believe there is a limitation for filtering by autonumber column.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
soumyadeep2201
Frequent Visitor

@Mira_Ghaly 

Ah😀..it worked. Thanks for the reply

@soumyadeep2201 

Glad it worked for you! 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,013)