Getting the output of previous formula

[Sharuk]

Hi, is it possible to get the values of formula and set it to another variable.

i'm using the following formula in gallery items

Sort(Filter(CompanyData,Company.Value = Drp_Company.Selected.Value && Region = Drp_Region.Selected.Result && CEO = Drp_CEO.Selected.Result),Title)

now i want get the output to set to another variable something like 

Set(vOutput, output(previous line formula))

i think, we can set it like by Set(vOutput,Sort(Filter(CompanyData,Company.Value = Drp_Company.Selected.Value && Region = Drp_Region.Selected.Result && CEO = Drp_CEO.Selected.Result),Title))

but is there a way something like
Sort(Filter(CompanyData,Company.Value = Drp_Company.Selected.Value && Region = Drp_Region.Selected.Result && CEO = Drp_CEO.Selected.Result),Title);
Set(vOutput, output(previous line formula))

[timl · Accepted solution]

Hi @Sharuk 

No, there's no formulaic 'keyword' to retrieve the output of the previous line in a formula.

I'm curious as to why you want to do this? What's the use case scenario?

As you say, this is the closest method to achieve what you want.

Set(vOutput,
Sort(Filter(CompanyData,Company.Value = Drp_Company.Selected.Value && Region = Drp_Region.Selected.Result && CEO = Drp_CEO.Selected.Result),Title))

It might also be worth noting that when you set the items property of a gallery control, you can access the items in the gallery using the BrowseGallery1.AllItems syntax. Depending on what you want to accomplish, this might provide an alternative to using a variable.