Forum Discussion
dj1996
May 08, 2023Copper Contributor
Automatically Rename Files in Sharepoint from lookup column
Hi, I have a flow to change a files name automatically, based on the column data. Which was working perfectly when all the columns were text inputs or choices. I then decided to change the Ve...
dj1996
Copper Contributor
Hi Micca0815
Thanks for your response. Unfortunately, selecting the 'value' field creates another 'apply to each' function within the current 'apply to each' function, within another 'apply to each' function.
Which then gives me this error:
Micca0815
Nov 02, 2023Iron Contributor
The first apply to each should be done for all items you get in return with your get file (properties only) action.
For the body of the HTTP action you could reference the vendor value for the current item of your get files (properties only) action as follows:
- HTTP body somehow with the following pattern:
.... 'FileLeafRef': items('Apply_to_each')?['VendorColumn']?['VendorColumnValue'] ....
For the body of the HTTP action you could reference the vendor value for the current item of your get files (properties only) action as follows:
- HTTP body somehow with the following pattern:
.... 'FileLeafRef': items('Apply_to_each')?['VendorColumn']?['VendorColumnValue'] ....