Answered

ThisItem.Status = This formula uses scope, which is not presently supported for evaluation. Data type: text

(0) Share

Report

Posted on by NewBee117

247

In a gallery I try to use ThisItem.Status as the default value for a text box, however, getting error: "ThisItem.Status = This formula uses scope, which is not presently supported for evaluation. Data type: text". Any idea why? I tried to change it to display a different field (for example, Segment), and it works. In the database, all are nvarchar(255). Any idea why?

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

Sort by

Pstork1 69,383 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Are you sure the Status column is included in your data source? Data sources can be set to filter out some columns. If status isn't included as a field in the records returned then this is the kind of error you will get.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (5)

Report
Copy link

Link copied!
Hi @NewBee117 ,

Could you please share a bit more about your data source? Is it a SQL Table or SP List or a CDS Entity?

Is there a column called "Status" in your data source?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please check if the "Status" column existed in your data source.

In addition, please also make sure the "Status" column is a normal Text type column in your data source, rather than a Complex type column, e.g. Choice type column in a SP List, A LookUp type column in a CDS Entity, ...

If the "Status" column is a Complex column, when you type a property selector operator (.) after the ThisItem.Status, the available properties would be listed:

ThisItem.Status.

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
NewBee117 247 on at

Like (0)

Report
Copy link

Link copied!

Yes, Status is a column in Azure SQL database, data type is nvarchar(255). Interestingly, this morning, even though the not supported message is still there, at least it is displaying the correct Status from the database. Maybe it is a message to ignore?

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @NewBee117 ,

Does the "Status" column display proper value within your app?

Currently, I could not reproduce your issue on my side. I think it is a temporary issue with "Formula bar result" mechanism in PowerApps Studio.

If the "Status" column could be displayed within your app properly, you could ignore this prompt info within your PowerApps Studio. If the issue still exists, please consider re-generate a new app based on your SQL Table data source, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
NewBee117 247 on at

Like (1)

Report
Copy link

Link copied!

Yes, the day after I created this thread, the "Status" column display proper value. So I'll ignore this message then.
Thanks,

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

Like (0)

Report
Copy link

Link copied!

I had the same problem. Again it corrected itself overnight.
Do you think this is a glitch?

Was this reply helpful? Yes No
skarvijayarag 6 on at

Like (1)

Report
Copy link

Link copied!

Is this issue resolved, I have collection data to display in a label, it throws error as "This formula uses scope" error. any idea why I am getting error?

Was this reply helpful? Yes No
Foss3 20 on at

Like (3)

Report
Copy link

Link copied!

I guess that your issue arises from your dataset not having a "ThisItem.Status" for all entries. Therefore PowerApps can display most statuses, but some are missing, so you get the error.
I replicated the error and fixed it by implementing an If()-clause that checks if Status is empty first.
Example: If(IsBlank(ThisItem.Status), "Status missing", ThisItem.Status)

Hope this helps to anyone new to this thread.

Was this reply helpful? Yes No
Kawalpreet 30 on at

Like (9)

Report
Copy link

Link copied!

use ThisItem.Status.Value

Was this reply helpful? Yes No
ArjunUXUI 3 on at

Like (0)

Report
Copy link

Link copied!

Excellent!!! 🙂 Works well

Was this reply helpful? Yes No