News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Not able to add the co...

Power Apps - Building Power Apps

Answered

Not able to add the column names with publisher in powerfx formula

(2) Share

Report

Report

Posted on by SN-06010449-0

Hi ,

Tried to add the powerfx formula which contains column name with publisher as "pu_columnnname", it's throwing error.

I have attached the picture below. please do let me know any options I need to enable.

Categories:

Using Apps Using Formulas

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

timl 33,680 on at

Like (1)

Report
Not able to add the column names with publisher in powerfx formula

Hi @SN-06010449-0

DBO_DV is correct. To add to this, the cause of this was a change in the way that the Search function worked. In the past, it was necessary to pass the logical name in quotes.

You can now just pass StudentFullName, rather than "pu_studentfullname"

Search(Filter(Loans, 'Loans (Views)'.'Current Loans'), txtSearch.Text,StudentFullName)
Verified answer

DBO_DV 4,415 on at

Like (2)

Report

Not able to add the column names with publisher in powerfx formula

Hey @SN-06010449-0,

Easy fix: You need to replace the double quotes (") with either single quotes (') or remove them completely.

Power Apps interprets everything enclosed in double quotes as a string and not as an object or column.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!