Command Bar Power fx not finding field

(1) Share

Report

Posted on by elzool

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!

All responses (12)

Answers (1)

elzool 12 on at

Like (1)

Report

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 71 on at

Like (1)

Report

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 12 on at

Like (0)

Report

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 71 on at

Like (5)

Report

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".

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 12 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 12 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 "..."

--> 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

Please mark my answer verified if this is helpful!
elzool 12 on at

Like (0)

Report

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 28,979 Moderator on at

Like (0)

Report

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});