cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Need to get additional trigger data returned from API but not in datapill

sgoseberg
Deputy Chef I
Deputy Chef I

I want to watch the creation of a new Excel file in OneDrive and am using the trigger "New file in OneDrive". In the following I want to list the worksheets available in that file using the action "List worksheets in Microsoft Excel". For this action I need the drive id and file id. The file id is provided in the trigger datapill. The drive id is not available in the datapill, but is returned by the trigger underneath the parentReference object.

2025-01-29_11-44-30.png

Is there any way to get that data in my action?

1 ACCEPTED SOLUTION

sgoseberg
Deputy Chef I
Deputy Chef I

Figured it out. You can use the Step Output from the trigger in the formula mode like 

2025-01-29_12-31-34.png

View solution in original post

1 REPLY 1

sgoseberg
Deputy Chef I
Deputy Chef I

Figured it out. You can use the Step Output from the trigger in the formula mode like 

2025-01-29_12-31-34.png