Answered

This formula uses scope, which is not presently supported for evaluation--- Text property

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have seen quite a few blogs/discussions regarding the issue "This formula uses scope, which is not presently supported for evaluation". But I don't seem to have noticed a concrete solution for this problem. Please refer my issue details as below...

Issue detail:

I have a few fields such as Country, City, Region, Street all of String datatype.. While the data for Country, City, Region are fetched without any issues, for the field Street, no data is fetched. For all these 4 fields, I get this message "This formula uses scope, which is not presently supported for evaluation".

Attachments:

Region_OK -- For the field Region, with no issues for data retrieval

Street_no_data -- For the field Region, with issues for data retrieval

Sample_data -- Sample data for the fields

I have tried recreating the app, recreating the custom connector etc...It does not seem to solve the problem. Could you please advise ?

Thanks,

Mahesh

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Error

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Drrickryp,

Thanks for the reply.
I am not using Excel as the source. I am using Azure SQL DB as the source (a sample dataset provided by Azure).

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Anonymous

This is a normal message. There is no error here.

When your formula has a ThisItem in it, it is referring to the record of the Gallery (or whatever it is in).

The formula editor cannot evaluate this because it ThisItem is in scope of the Gallery rows.

Think about it this way - in a Gallery, you only alter the formulas of the controls that are in the Template (appears as top row). So, how can the formula editor know what row you want to see as an evaluation for the formula result?

So...since it can NOT do that, it simply tells you that your formula use is in the scope of the Gallery and it cannot evaluate it for you.

This is NOT an error, this is perfectly normal to see.

If you're not seeing a value in the Gallery for street, then the issue is with your data, not the message you are seeing.

One thing you can do to troubleshoot is, in the Items property of the Gallery, place your cursor at the end of the formula (1 in the image below), you will have the opportunity to "dropdown" the table that it is producing (2 below). From there you can see all the values of all of the columns of the table for the Items. I would look there and see if there is a value for street.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi RandyHayes,

Thanks for the response. As suggested by you, I tried looking at the Items property of the collection. I could notice values only for a few columns...It is more to do with the data, I suppose.
Your suggestion was highly helpful. It can help me now to investigate as to why the data for the other columns are not getting populated in my collection.

Was this reply helpful? Yes No
nmagee 25 on at

Like (0)

Report
Copy link

Link copied!

Did you ever work out why their was no data Randy? I am facing a similar issue

Was this reply helpful? Yes No