query multiple columns and display in one

Occasional Contributor

Hello all!

 

I have a power app going that queries multiple sharepoint columns, and displays the output.  Basically, the app has several stages and multiple statuses in each stage.  The summary will show the latest and greatest stage as well as the status.  There is no direct sharepoint column for the 'overall latest status', but I now NEED there to be one. 

 

How can i create a column that will display what is in my app?  The code within my power app is below:

 

davyjones_0-1647285500184.png

 

1 Reply
A coworker suggested that I use a 'calculated' column, but I know that not only does this have to lookup one main column for reference, but depending on what is in that column, it needs to then look to ANOTHER column for that output.

Suggestions?