Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Converting Table Based Text Data into Operators -OR- Converting Text to Operator

(1) ShareShare
ReportReport
Posted on by 6
This is a repost of a question that didn't get answered I asked in formula help but cleaned up to be just the basics.
 
Problem. I have a table (sharepoint) that within a row are operators that I would like to utilize when imported into a gallery or other PowerApp locations for example (ThisItem.Title) The column type where the data is stored it single line of text. Whenever I reference one of the operator text fields instead of functioning like an operator it is functioning like text. I have tried various different things to accomplish this to no avail. 
 
Why: If I can get a user to input these operators into a table then I can have them create non standardized data with standardize data output across different tables. 
 
Example Table
ID Operator 
1 ThisItem.Title
2 ThisRecord.Title
 
Categories:
  • Verified answer
    Michael E. Gernaey Profile Picture
    41,002 Super User 2025 Season 1 on at
    Converting Table Based Text Data into Operators -OR- Converting Text to Operator
    Hi
     
    I am taking a guess here as I don't see a specific example.
     
    But like this
     
    Set(A,
          Switch(MyRecord.Operator
               "ThisItem.Title",
                  ThisItem.Title,
               "ThisRecord.Title",
                   ThisRecord.Title
          )
    ); 
     
     
    In a loop same thing
     
    ForAll(MyRecords,
         Collect(MyCollection,
             {
                 MyTextColumn: 
                     Switch(MyRecord.Operator
                      "ThisItem.Title",
                        ThisItem.Title,
                    "ThisRecord.Title",
                       ThisRecord.Title
                )
             }
        )
    );
     
    That's what you would have to do. You could always use an If but its just as long if not longer than the Switch.
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,635 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard