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 / Expected text or numbe...
Power Apps
Answered

Expected text or number at this point in formula

(0) ShareShare
ReportReport
Posted on by 84

GroupBy(
AddColumns(
Filter('Project Approvals', Text(ApprovalStatus) in ["Completed", "In Review", "Approved"]),
"TagTypeValue", Text(ApprovalStatus)
),
"TagTypeValue",
"Tags"
)    

Anyone know ,how to resolve this issue 

getting error at this point  Text(ApprovalStatus) Approval status is a choice field 

 

Categories:
I have the same question (0)
  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @sourav456,

    Modify as below:

     

     

    GroupBy(
    Filter(
    AddColumns(
    'Project Approvals', "TagTypeValue", ApprovalStatus.Value),TagTypeValue in ["Completed", "In Review", "Approved"]),
    "TagTypeValue",
    "Tags"
    ) 

     

    Here are some modification above, please check for details.

  • gcmfaizan Profile Picture
    1,022 on at

    Hi @sourav456 ,

    Your formula almost looks good, can you try this:

     

    GroupBy(
     Filter(
     AddColumns(
     'Project Approvals',
     "TagTypeValue",
     ApprovalStatus.Value
     ),
     TagTypeValue in ["Completed", "In Review", "Approved"]
     ),
     "TagTypeValue",
     "Tags"
    )

     

     

     

    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.

     

    Thanks!

  • sourav456 Profile Picture
    84 on at

    not working

     

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @gcmfaizan ,

    I have some syntax wrong before, please check this

    GroupBy( Filter( AddColumns( 'Project Approvals', "TagTypeValue", ApprovalStatus.Value),TagTypeValue in ["Completed", "In Review", "Approved"]), "TagTypeValue", "Tags" )

     

  • sourav456 Profile Picture
    84 on at

    its not working, my choice field name is Approval Status and choice table which connected with choice field is also named Approval status i think this is reason that code is not working

  • sourav456 Profile Picture
    84 on at

    Still not working

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @sourav456,

    Show me the error, specific error message.

    BTW, what is your data source, Dataverse?

     

    I have a test on my side, and if this choice field is from SP list, it works as expected.

    If it is Dataverse table, I think you need to modify as below:

    GroupBy( Filter( AddColumns( 'Project Approvals', "TagTypeValue", Text(ApprovalStatus)),TagTypeValue in ["Completed", "In Review", "Approved"]), "TagTypeValue", "Tags" )
  • sourav456 Profile Picture
    84 on at

    yeah its from dataverse table

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @sourav456,

    Have you tried the formula I provide in my previous reply?

    GroupBy( Filter( AddColumns( 'Project Approvals', "TagTypeValue", Text(ApprovalStatus)),TagTypeValue in ["Completed", "In Review", "Approved"]), "TagTypeValue", "Tags" )
    
  • sourav456 Profile Picture
    84 on at

    Screenshot 2023-12-05 125145.pngScreenshot 2023-12-05 125202.png

    this warning that i am getting

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard