Answered

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?

(0) Share

Report

Posted on by Ms-PowerRanger

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?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Carlosr Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried selecting the field using the data panel?

I just tested this and it works:
Carlosr Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I just realized what the issue is:

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:

In this case, I am asking for the field of a selected row, so it can properly evaluate the result.
Ms-PowerRanger 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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.