Answered

Expected text or number at this point in formula

(0) Share

Report

Posted on by sourav456

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:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
sourav456 84 on at

Like (0)

Report
Copy link

Link copied!

not working

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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" )

Was this reply helpful? Yes No
sourav456 84 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sourav456 84 on at

Like (0)

Report
Copy link

Link copied!

Still not working

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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" )

Was this reply helpful? Yes No
sourav456 84 on at

Like (0)

Report
Copy link

Link copied!

yeah its from dataverse table

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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" )

Was this reply helpful? Yes No
sourav456 84 on at

Like (0)

Report
Copy link

Link copied!

this warning that i am getting

Was this reply helpful? Yes No