Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : 96sHFrz+Zo3xyTdQ4Sjze3
Power Platform Community / Forums / Power Up Program - Power Up Final Challenge / Power Fx Column
Power Up Program - Power Up Final Challenge
Answered

Power Fx Column

Like (2) ShareShare
ReportReport
Posted on 9 Apr 2025 19:04:20 by VC-06031705-0 15
I was trying to get the current location column using Power Fx but I coulnd't use the switch fc. Could you advise to do it? Thanks.
Categories:
General Discussion
  • VC-06031705-0 Profile Picture
    VC-06031705-0 15 on 14 Apr 2025 at 18:49:12
    Power Fx Column
    Thank you. I got it. 
  • w.p Profile Picture
    w.p 3,446 on 14 Apr 2025 at 05:36:14
    Power Fx Column
    Just following up on this, if you have any more queries.
    For housekeeping, please mark the post as answered, if you have no more queries.
  • Verified answer
    w.p Profile Picture
    w.p 3,446 on 12 Apr 2025 at 18:05:00
    Power Fx Column
  • w.p Profile Picture
    w.p 3,446 on 12 Apr 2025 at 17:55:07
    Power Fx Column

    "Shelter Status" is a choice column data type. Don't change it to text.

  • VC-06031705-0 Profile Picture
    VC-06031705-0 15 on 12 Apr 2025 at 08:19:03
    Power Fx Column
    I fixed this changing the data type of the Shelter Status column from choice to text, and comparing texts in the logic. I'm not sure if it's the right approach but I couldn't get the other comparation work. 
  • Suggested answer
    w.p Profile Picture
    w.p 3,446 on 09 Apr 2025 at 19:18:59
    Power Fx Column
    You can use the Switch or If function in the fx Formula, but you need to change to this column type first.
     

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,626 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,962 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans