Hai all,
I need to extract the control value in the gallery.
My scenario is,
In previous Screen i am using a collection to get the Specific Record from the sharepoint list
Gallery Item Property Formula are,
Distinct(
Filter(selecteditems,Date >= Date(Text(dateFrom.SelectedDate,"[$-en-US]yyyy"),Text(dateFrom.SelectedDate,"[$-en-US]mm"), Text(dateFrom.SelectedDate,"[$-en-US]dd"))
&& Date <= Date(Text(dateTo.SelectedDate,"[$-en-US]yyyy"),Text(dateTo.SelectedDate,"[$-en-US]mm"), Text(dateTo.SelectedDate,"[$-en-US]dd"))),Store)
Above Collection Name is - selecteditems
i am getting the expected output in gallery but after getting the value in gallery i am trying to put those record in Another one collection to pass power automate .
formula I am trying to put in - ClearCollect(colReportRemarks,Gallery1_31.AllItems)
i am getting in Value in control i need to extract the Label value
I am attaching the related image below
Value in the collection - Store Name
Please help me out
WarrenBelz
109
Most Valuable Professional
Michael E. Gernaey
82
Super User 2025 Season 1
MS.Ragavendar
72