You’re offline. This is a read only version of the page.
113
Hi there,
In the image below is a GET ITEMS action that is retrieving 2 ROWS from a sharepoint list.
I need to extract each value of the 2 ROWS to create a SINGLE ROW like this
I though I had done it(pic below) but the schema failed, since I added manually a "2" to the second row column headers.
Any suggestion? thanks in advance!!
thanks @efialttes! , that sound it will work. what if I have more than 2 items?
Hi!
I would use the following WDL expressions
first(body('Get_items')?['value'])
last(body('Get_items')?['value'])
First expression provides acces to your first item from 'Get items' output
Second expression provides acces to your last item from 'Get items' output
So if you need to show AMONT field value from item#1:
first(body('Get_items')?['value'])?['AMOUNT']
Same aproach for second item:
last(body('Get_items')?['value'])?['AMOUNT']
Hope this helps
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
