We have a power automate workflow writing data from forms to a table in excel. Depending on the answer to one question in the form, the data needs to be written to a different excel spreadsheet (spreadsheets are identical but separated for access requirements). We need to populate the individual sheets in real time as opposed to parsing the forms dataset after the fact.

When I try to pass a dynamic file id or dynamic file path to the file field, I get an error which suggests that the value in the file field is being interpreted as a string, which it is. I would have expected it to try to lookup the file itself based on the provided string. It appears that the only way to get this action to work is to use the file picker to select the file obj itself.

Is there anyway to dynamically select the file if I know the file location/id?