Record Selector not showing data when primary field is a Formula (that includes a Link to table field)

Application Builder
1

My primary field “Prozess_ID” in the parent table “Prozesse” is a Formula - see screenshot 1

Screenshot1
Screenshot1566×481 49.1 KB

In the Application Builder I have a form with a Record Selector. I want to select records from the parent table. So the dropdown from the Record Selector should show the values from the primary field (with an additional suffix “Beschreibung” = explanation)
This doesn’t work.
It shows "object “Object”. See Screenshot 2

Screenshot2-WebFrontend
Screenshot2-WebFrontend318×203 13.2 KB

Screenshot 3 shows what I’ve built.

Screenshot3-ApplicationBuilder
Screenshot3-ApplicationBuilder1336×827 109 KB

I guess this problem comes because the primary field is a Formula, is that right?
But I also guess this should work…?

2

It has indeed something to do with the primary field being a formula. The problem is that the formula doesn’t returns a Single text field, but actually a list of items with just a single item. This is because a Link to table field is always considered to be a list of items, even if only a single item is selected.

To bypass the problem, you need to convert to result to a single text. This can be done with the use of the join() function.

concat(join(field('Prozesskürzel'),''),totext(field('Prozessnr')))
3

This works for me - thank you for the solution, @frederikdc