cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sb_teal
Helper I
Helper I

Custom column from Custom table not available in modern commanding PowerFX formula bar

Hi,

 

I am editing the command bar for the Main form of a custom entity.

 

I have made a Command button using the modern command designer however at least one of the fields in my custom table is not available in the intellisense.  Intellisense is not finding it by the display name, and if I enter the schema or logical name, it says the field does not exist.

 

sb_teal_0-1655848354174.png

 

sb_teal_1-1655848759285.png

 

sb_teal_2-1655848770886.png

Any ideas on why I can't find it? This is a recently added field, but I've published customisations since adding it. It looks like all the other fields from the table are available but not this one. Most of the fields were created before the recent changes to the modern solution explorer (the ones published around the time of MS Build) but this field was added after those upgrades.

1 ACCEPTED SOLUTION

Accepted Solutions
sb_teal
Helper I
Helper I

In case anyone else has this problem, in order to have the command bar pick up latest changes to the data source you need to open the default command library for the model driven app, find the correct data source and refresh it.

View solution in original post

6 REPLIES 6
dpoggemann
Super User
Super User

Hi @sb_teal ,

 

This might not be the situation but it appears you are using the name of the field vs. the Display name.  Example is if the Display name is 'Confirm Date' and the backend name of the field is teal_dateconfirmed wouldn't you do the following?

Patch(Sheds,Self.Selected.Item, {'Shed Status' : 'Shed Status'.Order, 'Confirm Date' : teal_dateconfirmed, 'Confirm Date' : Now()})

 

Sorry if this is off the path.

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Hi @dpoggemann thanks for the suggestion, this doesn't work.  For all other fields the display name is available via intellisense, but for some reason this field (Display Name = 'Date Order Confirmed', logical name = teal_dateconfirmed) isn't available - it tells me the column doesn't exist but it does exist.

 

sb_teal_0-1655865112344.png

 

sb_teal_1-1655865243290.png

 

Hi @sb_teal 

 

Can you please check teal_dateConfirmed file field is available in the table or not

 

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Not sure what you mean by "file field" but the field is in the table, as shown in screen shot below:

 

sb_teal_0-1655875355357.png

 

sb_teal
Helper I
Helper I

In case anyone else has this problem, in order to have the command bar pick up latest changes to the data source you need to open the default command library for the model driven app, find the correct data source and refresh it.

limontora3
Frequent Visitor

Thank you! It works for me too.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Users online (2,063)