Powerapps automatically changes my code into something that doesn't function

(0) Share

Report

Posted on by HansHeintz

704

In an earlier post I had an issue with a collection that is Clearcollected from a table and shown in a gallery.

If I wanted to get to the record from the gallery that did not always work.

When viewing the collection in powerapps I noticed that there is an automatic Guid column in the table and thuis in the collection. In my case it is called cra27_diereventid. The Table is DierEvent. The Gallery is GalleryDierEvent

So if I do:

LookUp(DierEvent;cra27_diereventid=GalleryDierEvent.Selected.cra27_diereventid)

I get to the record and can do anything I like with it.

But at one point connection between gallery Item and record seemed lost and things stopped functioning.

I discovered that the line above had automatically changed to
LookUp(DierEvent;DierEvent=GalleryDierEvent.Selected.DierEvent)

Which does NOT function. No errors but no go.

Does this mean that everytime I publish my app from now I have to check if this line has not been "improved"?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

SkiDK 1,016 on at

Like (0)

Report
Copy link

Link copied!
Check if this helps:

LookUp(DierEvent, cra27_diereventid=GalleryDierEvent.Selected.cra27_diereventid)
I don't think using a ';' works there.

Was this reply helpful? Yes No
Dimitri-VDL 133 on at

Like (2)

Report
Copy link

Link copied!

@SkiDKthis is due to the language of the Browser/Office, Dutch for example will use semicolons (;) instead of commas (,) ... This has not been an issue for me in the past.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @HansHeintz ,

Is the cra27_diereventid a Unique Identifier type column in your DierEvent Entity?

Have you turn on the "Relational data, option sets, and other new features for CDS" functionality within the Advanced settings of App settings of your app?

Actually, the DierEvent is the Display name of the cra27_diereventid column (logical name) in your CDS Entity. Currently, when use column value of data source within an app, it would use the Display name rather than logical name as referenced column in default.

Please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/display-names-and-guids-for-canvas-apps-graduate/

Based on the formula that you provided, I think it should work as expected. Please make sure you have turned on the "Relational data, option sets, and other new features for CDS" functionality within the Advanced settings of App settings of your app.

Also please make sure the DierEvent is the Unique Identifier column/Primary Column in your CDS Entity. On your side, you could type the following formula:

LookUp(DierEvent.

then all available column names (Display name) would be shown up as below:

Note: The Unqiue Identifier column/Primary Column has same name as your CDS Entity. The screenshot as below:

Please consider take a try to re-create a new app based on your CDS Entity, then try the following formula:

LookUp(DierEvent; DierEvent = GalleryDierEvent.Selected.DierEvent)

or

set the Text proeprty of a Label to following:

LookUp(DierEvent; DierEvent = GalleryDierEvent.Selected.DierEvent, 'Primary Name')

then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No