You’re offline. This is a read only version of the page.
Announcements
1,265
I have a Flow that performs a Get items. The Get items - Filter Query is including records from the previous month. I would like to capture the value in a Column named 'DateEntry' in the first record of the Get items output. How can I obtain this value and use for further steps in the Flow?
I need all the Get items information so a Get item isn't feasible. I need to use the date to identify the Month, Year and Number of Days in the identified month.
Thanks
Hello @RJF61 ,
you can use the first(...) expression on the output of 'Get items' to take only the first item and then select the desired value from the JSON as explained here: https://tomriha.com/how-to-get-a-specific-value-from-a-json-object-in-power-automate/
Or you can use 1 in the 'Get items' Top Count field, that way it'll return only one item from the list - you can use the dynamic content, it'll add 'Apply to each' but since it'll return only 1 item it won't matter.
Share
Report
All responses (
Answers (
