I have a simple SharePoint list named "My Mapping List"
My simple job is to put together the list of MySubCat values for a given MyCat value.
This is the way I'm doing it...
This works fine in the simplest of all possible apps:
One Screen
One Text box
Text set equal to this formula
Result:
But when I add the same screen, text box, and formula to a more complex app built dynamically from the same SharePoint list using Power Apps (which has a Browse, Detail, and Edit screen), only the FIRST value is returned...
Inside the more complex app I have also experimented with the example found here in the documentation...
https://learn.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate
In this case, the expected output does result...
I don't know what to do.
Is there an app level setting that needs to be adjusted?
Something that (apparently) affects tables when the data source is a SharePoint list,
refer formula in this link..
https://www.c-sharpcorner.com/blogs/concat-and-concatenate-functions-in-powerapps