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))
Solved! Go to 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.
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.
User | Count |
---|---|
253 | |
122 | |
106 | |
54 | |
48 |