Can I use Arcade to 'append' two feature layers to use as a data source in a Dashboard?

[tigerwoulds]

I'm a complete novice with arcade and would like to know if what I'm envisioning is possible.

I have 2 hosted feature layers with slightly different schemas. What I want is to 'append' these into a single layer/data source that I can use in my dashboard. 

Rather than using the ArcGIS Python API to handle creating a new hosted layer, the append, and field mappings, can I use arcade to create a FeatureSet (?) to use as a data source in my dashboard? 

Layer One Fields: Name_1, Color_1, Type

Layer Two Fields: The_Name, The_Color, Type

Appended Layer: Name, Color, Type

[ArielLow2146 · Accepted solution]

You could use a data expression in Dashboards to do this. You can find an example here. You're essentially using Arcade to return a feature set of both layers which can then be used in a variety of Dashboard elements.

[tigerwoulds]

Well, it took me about a day but I figured it out! Thanks so much!

[JohnBachman]

Hey Tiger,

If you could share your code that would be great! I am wanting to do the same thing but am having trouble.