Hello
I have flow with 2 getrows actions.
1st action retrieve data filtered by "creation day" - assets, added to database today
Data contains columns:
Asset Name
Purchase Date
Supplier ID
2nd action retrieve data from 2nd database, and contains columns:
Supplier ID
Supplier Name
I need to build HTML table with data from 1st getrows action, but replace Supplier ID with Supplier Name from 2nd action.
Any help or advice will be greatly appreciated.
Afaik views is not supported im mysql actions. I've created view but can't access it in flow
upd:
i was wrong. mysql views supported. It cant't be selected in drop down list, but can be added manually - [dbname].[viewname].
Thank you @krootz
Hello @RmanNzrnk ,
I'd add the action 'Get a row' inside the 'Apply to each' where you're processing the rows from the 'List rows' action.
For each row you're processing from the first file, 'Get a row' from the second file where 'Supplier ID' column is equal to 'Supplier ID' dynamic content from the 'List rows' action.
@RmanNzrnk if you're using get rows from a database either SQL server or Oracle, I suggest you create a view in the database schema with a join between the two tables on Supplier ID with all the columns that you need. You can then use that view for your get row action instead. It's cleaner and will help with performance especially if you have a lot of records. If you can't create a view, then try @ChristianAbata 's recommended solution below.
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2