This formular uses scope, which is not presently supported for evaluation

(1) Share

Report

Posted on by MaxwellDziya

Hi, Please help

Im using the expression below in a gallery:

AddColumns(
    GroupBy('itemLedgerEntries', itemNo, GroupedItems),
    TotalRemainingQty,
    Sum(GroupedItems, remainingQuantity)
)
If i hover the expression i get the below,showing the correct values
 
However in the gallery i have the following not showing any data and message(This formular uses scope, which is not presently supported for evaluation) for TotalRemainingQty :

 
Where exactly am i getting it wrong? 

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

How do galleries show grouped by items in a column on a single row? If this is what the provided screenshots imply.

Watching this for an answer.

Was this reply helpful? Yes No
MarkRahn 1,229 Super User 2025 Season 2 on at

Like (0)

Report

Hi Maxwell,

The message "This formula uses scope, which is not presently supported for evaluation" just means that the instant view of the value can not be displayed in the formula editor. If your gallery was connected to a predefined Collection, you would still see the same thing. This is not the reason the value is not displaying.

I did some testing with similar formulas. I am able to display the TotalRemainingQty in the Gallery.

Can you check the settings on the textbox you are using for the TotalRemainingQty? From the screenshot you have, the Font is blank. (I tried that as well.)

Try adding a new textbox to the Gallery Template and set the Text to: ThisItem.TotalRemainingQty

If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a Like.

Thanks
-Mark

Was this reply helpful? Yes No
MaxwellDziya 15 on at

Like (0)

Report

Hi Mark,

Thanks for responding , however even after adding new text field no joy

Was this reply helpful? Yes No
Verified answer

MaxwellDziya 15 on at

Like (0)

Report

Finally resolved it by changing the expression.

Was this reply helpful? Yes No
MarkRahn 1,229 Super User 2025 Season 2 on at

Like (0)

Report

Hi Maxwell,

Can you provide more information on how you changed the expression so that other users might know they answer if they have similar problems?

Thanks

-Mark

Was this reply helpful? Yes No
IAmIntractable 278 on at

Like (0)

Report

I'm guessing....but is something like a .value missing:

ThisItem.TotalRemainingQty.Value

Was this reply helpful? Yes No
MaxwellDziya 15 on at

Like (1)

Report

Here is the expression that resolved the issue:

AddColumns(
GroupBy(
AddColumns( 'itemLedgerEntries',RemQty,
Sum(remainingquantity)
),
itemNo,
GroupData
),
TotaRemQty,
Sum(
GroupData,
RemQty
)
)

Was this reply helpful? Yes No