Unanswered

Delegation for Excel

(1) Share

Report

Posted on by gcoates

Hi - any update on when delegation will be supported in Excel? It's been "Coming Soon" for a long time now and the 500 row limit is holding up progress in my organisation significantly. I suspect the same applies for others? Please can we have a date for when this will be released so we can manage expectations.

Thanks

Graham

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-micsh-msft on at

Like (0)

Report

Hi @gcoates,

If you mean the other datasource, yes.

There is an idea posted in the idea forum:

Fix 500 Record Limitation

Please consider vote it up so that delegation would be considered in a higher priority.

I believe the Product Team are aware of the importance of the delegation, and they are trying to make it.

In addition to the data source , there are alos functions need to be considered when enable the delegation.

Delegable data sources

Regards,

Michael

Was this reply helpful? Yes No
AN-23072011-0 on at

Like (0)

Report

We don't yet have an ETA for Excel delegation support. As mentioned in the previous reply, there are a number of other data sources that do support delegation - such as SharePoint, SQL, Dynamics 365 etc. You could consider moving to one of these data sources in order to get delegation support.

Was this reply helpful? Yes No
gcoates 65 on at

Like (4)

Report

Frankly "no ETA yet" is a poor answer. It was you guys that set the expectation of "coming soon" and that status has not changed for months and still no ETA. Other (paid) data sources may have delegation however the other corporate db's that I am using PowerApps to augment export in Excel. PowerApps offers the ability to extend the usefulness of these db's to my users however if Excel delegation is not to be supported soon I will need to look at alternatives that don't have the restriction (e.g. Google Apps).

At least consider raising the limit to something useable while you figure out an ETA you can stand behind?

Thanks
Graham

Was this reply helpful? Yes No
mh1990 14 on at

Like (0)

Report

Is MS facing difficulty to apply delegation to Excel as database? It seems delegation is yet available now...

Was this reply helpful? Yes No
Verified answer

CFS 18 on at

Like (1)

Report

@gcoates wrote:
Frankly "no ETA yet" is a poor answer. It was you guys that set the expectation of "coming soon" and that status has not changed for months and still no ETA. Other (paid) data sources may have delegation however the other corporate db's that I am using PowerApps to augment export in Excel. PowerApps offers the ability to extend the usefulness of these db's to my users however if Excel delegation is not to be supported soon I will need to look at alternatives that don't have the restriction (e.g. Google Apps).

At least consider raising the limit to something useable while you figure out an ETA you can stand behind?

Thanks
Graham

Re to the red font in above quote:
Fyi. The limit has been raised to 2000 now for data sources that don't support delegation (e.g., the OneDrive Excel).
Thx

Was this reply helpful? Yes No