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

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 Community Champion
Community Champion

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
Frequent Visitor

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 Community Champion
Community Champion

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

sparky13
Frequent Visitor

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,826)