web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Converting Table Based...
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:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,963 Moderator on at
    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 294 Most Valuable Professional

#2
11manish Profile Picture

11manish 210

#3
Valantis Profile Picture

Valantis 169

Last 30 days Overall leaderboard