I need to check book titles to determine whether they start with "The " or "A ".
It seems impossible. I can find "The" and "A", but that includes other words, such as "Theory" or "Access", which I don't want.
Is it possible to use TrimLeft to find "The " or "A "? If not, what workarounds are available.
This will result in a sortable field that doesn't put all of the titles that start with "A " at the top and "The " together in latter part of the list.
I didn't see that option. I'll look again, though, thanks.
The option I did see in the calculated field editor was "BeginsWith", which doesn't accept the trailing spaces.
This is what I can see in the Calculated Field editor.
Note that if I try to include a trailing space after The, I either get a syntax error or it is trimmed off.
@gpgeorge, Okey, a work around will be using a Power Automate Flow that is triggered when Dataverse record is Added, Modified, and use this expression to update the value of a Text Column in your table:
Or(startsWith(variables('varString'),'The '),startsWith(variables('varString'),'A '))
Note, the result of this formula is true or false. If it starts with "The " or "A ", it will give you true, else it will give you false.
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.
Keep up to date with current events and community announcements in the Power Apps community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!