cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hotely
Level: Powered On

Re: 500 record limit again in Azure SQL Database

Hi @Meneghino

 

thank you for your efforts

 

2017-08-22_1057.png

 

I get the blue dot in the Gallery, I covered the text inside.

 

Thanks again

Meneghino
Level 10

Re: 500 record limit again in Azure SQL Database

Hi @hotely

If you click on the blue dot then it will show you exactly where the issue is by underlining, see the example below.

It would be useful to see in your case.

__.JPG

hotely
Level: Powered On

Re: 500 record limit again in Azure SQL Database

Hi @Meneghino

 

Actually it's the Lookup

 

2017-08-22_1123.png

 

It says: 

 

2017-08-22_1124.png

 

😞

Meneghino
Level 10

Re: 500 record limit again in Azure SQL Database

Hi @hotely

I understand that Name has 133 rows, so until you get to 500 rows then the blue dot is not a problem.

In any case, PA Studio may be confused by the disambiguation operator, so you could try this syntax:

AddColumns(Opportunity; "Name"; Lookup (Name; NameID = Opportunity[@NameID]))

This should still work, but may remove the blue dot.

If it does not remove the blue dot or does not work, then you could try to change one of the column names so that you do not need disambiguation.  This may remove the bule dot, but not guaranteed.

Please let me know

View solution in original post

Highlighted
sparky13
Level: Powered On

Re: 500 record limit again in Azure SQL Database

It does not appear as though disambiguation has been resolved for delegation (specifically dealing with > 500 records).

 

Any thoughts on whether it will be happening?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 102 members 4,300 guests
Please welcome our newest community members: