cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ms-PowerRanger
Regular Visitor

The field of a Data source has a forward slash '/' as part of the name. How do I include it in Power Apps Gallery using ThisItem?

In PowerApps, I'm using a data source from a SharePoint list that has a forward slash as part of the field name. For example, there is a column named 'Edit/Rework'. I have a Gallery in PowerApps where I'm trying to assign that column to the 'text' property of a label via ThisItem.'Edit/Rework'. PowerApps gives an error "This formula uses scope, which is not presently supported for evaluation" How do you specify a column that contains a / in it? Is there an escape character that I can use?

1 ACCEPTED SOLUTION

Accepted Solutions
Carlosr
Microsoft
Microsoft

Have you tried selecting the field using the data panel?

 

I just tested this and it works:

 

Carlosr_1-1628088526717.png

 

Carlosr_0-1628088489026.png

 



View solution in original post

4 REPLIES 4
Nogueira1306
Super User
Super User

When you insert "ThisItem" search for that collumn. When you see it, press it

Carlosr
Microsoft
Microsoft

Have you tried selecting the field using the data panel?

 

I just tested this and it works:

 

Carlosr_1-1628088526717.png

 

Carlosr_0-1628088489026.png

 



Carlosr
Microsoft
Microsoft

I just realized what the issue is:

Carlosr_0-1628089022679.png

 

This is not an error.  The panel under your formula editor is trying to evaluate the value of your formula.  This is not always possible.  In this case, it doesn't have a way to know which row to show, so it has no "scope".  This is only used for troubleshooting, and will not affect your application.

 

When a formula can be evaluated, it will display the result:

Carlosr_1-1628089131752.png

 

In this case, I am asking for the field of a selected row, so it can properly evaluate the result.

You helped me realize that the slash '/' wasn't the problem.  It was the data type.  I had a column with a slash in it that was a Person data type and needed to add DisplayName to the end.  For Example ThisItem.'Lead/Mgr'.DisplayName.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,668)