Hello,
I have a Flow which updates an Excel document based on a given Forms response. This Excel document is formated close to the example below:
Patient1 | P1_TableX |
Patient2 | P2_TableX |
Patient3 | P3_TableX |
And so on and so forth...
Basically the same set of tables for each patient.
These tables have different names (P1Table X, P2Table X) because even though they contain the same rows (same expected data format) they contain different values in each cell.
My Flow then receives the Forms input and, after processing this data, is meant to update this Excel file with said data.
Everything works fine if I'm just working with one single table (Ex: selecting just "P1TableX" in the Update a row action) but, the Flow must update the correct table according to the ID ("Patient 01") from input (forms).
This table name is an expression which combines Forms processed data to generate a string that will match the right table name in the excel document.
Is it possible to reference a table from dynamic data? (Table name = expression/output)
I have tried other solutions to similar problems but they didn't work.
Thanks in advance,
Giulianno Iori.
Bumping this post as I am still searching for possible solutions. Anyone has any ideas?
User | Count |
---|---|
90 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
134 | |
54 | |
47 | |
36 | |
25 |