Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Command Bar Power fx not finding field

Posted on by 10

I'm getting started with Command Bar and Power fx and running into an issue.

I have a new button on a custom entity I would like to associate with a new field that is a checkbox. When the button is selected, check the box.

Command Bar - Main Form

Entity = 'Text Messages'

Field = 'Follow Up Complete'

The language I am using now to test entering information when the button is selected works.

Patch('Text Messages',Self.Selected.Item,{'Recipient Phone Number':"1"})
 
The problem is that when I reach the part where I should define the field I want, Follow Up Complete, the intelligent list doesn't have it available.
If I manually type it in, it fails.
Patch('Text Messages',Self.Selected.Item,{'Follow Up Complete':"1"})
Why might the field be unavailable?
Thanks in advance!
  • elzool Profile Picture
    elzool 10 on at
    RE: Command Bar Power fx not finding field

    This is terrific information.  

    Within minutes of reading this I've published in our sandbox and will have a peer review today.

    Why the field wasn't simply available, I do not know, but cannot thank you enough for finding this question and responding.

    You're the best Nik!

  • DynamicsNik Profile Picture
    DynamicsNik 71 on at
    RE: Command Bar Power fx not finding field

    Hi elzool,

    i´m really happy to hear that :)

    If you edit formulars from the FX command bar, the component library is automatically generated/updated and packed into the current solution you are working with.

    I made the experience that changes in the FX command bar sometimes are not directly transferred to the app, so then i open the component library to "force" the edit. I guess they should normally have the same formulars but i noticed that the FX command bar is still a little bit slow/buggy. So if prefer to work in the library

    hope it helps you

    I would like if you can verify my answer :)

  • elzool Profile Picture
    elzool 10 on at
    RE: Command Bar Power fx not finding field

    Nik, this is fantastic!

    Thanks so much for the information!!

    Using open component library did allow me to find the field that was 'missing'.  

    Would I then want the place the rest of the Power fx command for that button into the component library command area?

  • Verified answer
    DynamicsNik Profile Picture
    DynamicsNik 71 on at
    RE: Command Bar Power fx not finding field

    Hi,

    i had exactly the same problem:

    The command bar of power fx was not showing the required dataverse field. I tried it with technical name and quotes and so on but it didn´t appeared.

    Then i switched to "Open component library".

    pastedimage1666335838738v1.png

    At that point my dataverse refreshed the new fields were available.

    When i typed the required formular with the required field it directly appeared.

    Best regards

    Nik

  • elzool Profile Picture
    elzool 10 on at
    RE: Command Bar Power fx not finding field

    It has not been resolved and at this point I may try opening a ticket with them on the issue.

    I'll follow up should I go in that direction.

  • vikramkshatri Profile Picture
    vikramkshatri 5 on at
    RE: Command Bar Power fx not finding field

    Hi elzool

    Is this resolved? I am facing the same problem and yet to get the solution. Please post the answer if the issue got resolved.

  • elzool Profile Picture
    elzool 10 on at
    RE: Command Bar Power fx not finding field

    Unfortunately this did not make the field available.

    Completely reasonable that it should, but no such luck.

    I'm still working at this as I can, but flummoxed as to why the field wouldn't be available.

  • Consultim Profile Picture
    Consultim 10 on at
    RE: Command Bar Power fx not finding field

    Had the same issue.

    --> Open component library (top right below your envorinment)

    --> Navigation bar on the left --> Data --> refresh you Dataverse table via "..."

    pastedimage1662117341420v1.png

    --> Navigation bar on the left --> Tree view --> components (your component should already be selected) --> above the navigation bar you find a dropdown which shows "OnSelected", switch it to "Visible", now you'll see the formula you typed in at the Command Bar designer, now try again in this formular bar to find your column

    in my case it worked with the self.selected.item formular

    pastedimage1662117382925v2.png

    Please mark my answer verified if this is helpful!

  • elzool Profile Picture
    elzool 10 on at
    RE: Command Bar Power fx not finding field

    I have tried this with both the schema and logical names, which are the same except for capitalization and neither of those worked either.

    I even utilized attribute manager in XRM toolbox to change the schema name of the existing new field.

    That still did not work.

    I was hopeful the schema name change was going to do the trick, but no such luck.

    Other thoughts?

  • Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Command Bar Power fx not finding field

    Hi,

    Please try below code. You need to replace new_isvalid with follow up complete field schema name

    Patch('Text Messages',Self.Selected.Item,{'new_isvalid':true});

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,064 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,750 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans