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!

I have the same question (0)

All responses (12)

Answers (1)

Bipin D365 28,983 Moderator on at

Like (0)

Report

RE: Command Bar Power fx not finding field

Hi,

Try to specify field schema name in single quote and value with true as below

'new_isvalid':true

Was this reply helpful? Yes No
elzool 12 on at

Like (0)

Report

RE: Command Bar Power fx not finding field

Where would the single quotes come in as I don't see any double quotes?

Was this reply helpful? Yes No
Bipin D365 28,983 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});

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
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!

1 people found this reply helpful.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Verified answer

DynamicsNik 73 on at

Like (6)

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

1 people found this reply helpful.

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No