Column changes not reflected on model driven Power Fx command bar.

(0) Share

Report

Posted on by HiroakiSasaki

We are writing Patch action on a command button on a model driven main grid.

We have changed display name of an existing column and added two new columns. All of them are lookup columns.

After the change, we came back to the editor of Power Fx command bar, but the changes are not reflected, so the names of new or edited columns are not recognized ;(

It seems there is no menu or button to refresh table schemas.

Any ideas to solve this problem?

What we’ve done is:

- Clear browser cache

-Delete the table from model drive app and add it again

-Add a new custom button and rewrite the formula

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (3)

Report

@HiroakiSasaki

You need to load the component library from any command button you have, Then click File Save and then Publish and then reload your command editor again , the column should re-appear.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (3)

Report

@HiroakiSasaki

I have details the solution below in case it is not clear:

https://onlinemgblog.wordpress.com/2022/09/29/power-fx-metadata-not-refreshing/

Was this reply helpful? Yes No
HiroakiSasaki 73 on at

Like (0)

Report

@Mira_Ghaly
Thank you for your quick help!!
You saved our time a lot, now we see the new columns.
Your blog seems great, too, We will time to time refer to it.

Was this reply helpful? Yes No
Btr1 36 on at

Like (0)

Report

I still cant see this working. i opened as mentioned in the blog. saved/published several times. still same problem. custom columns no visible in function.

Was this reply helpful? Yes No
Big Kahuna 42 on at

Like (0)

Report

Yep - I've tried this too. It might have worked once but it doesn't seem to work anymore. If I open the component designer it can see the newly added fields, and I can use them in my formulas. However if I return to the command designer it doesn't see them and the formulas don't run. It also seems to lock itself out in the editing process which is really frustrating.

Was this reply helpful? Yes No
dandanannan 2 on at

Like (0)

Report

1. After creating the table, click "Advanced", then "Publish Table".

2. On the app editing page, go to "Data" on the leftmost panel, choose "Add Data", then search for and click the new table.

Was this reply helpful? Yes No