cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewBee117
Advocate V
Advocate V

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

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?

 
 
1 ACCEPTED SOLUTION

Accepted Solutions

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Pstork1
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
v-xida-msft
Community Support
Community Support

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.

9.JPG

 

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

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

Thanks,

 

 

I had the same problem. Again it corrected itself overnight. 

Do you think this is a glitch?

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,066)