You’re offline. This is a read only version of the page.
Announcements
12
Step 1. Created a flow starting with SQL "When an item is created". Trigger works fine.
Step 2. Added a step with SQL "Transform data using Power Query". Transformations work fine. Filters rows, expands related tables, formats columns, etc.
Challenge is how do I get the record ID from the new record in Step 1 and run Step 2 only for that record ID????
That is, if the new record in the SQL table is ID number 100, how do I pass that ID to Power Query so it does data transformation only on ID 100?
Step 3 will be. Send an email of about that new record ID with fields from the Power Query transformations.
Sorry I am REALLY new to Flow. Please don't assume I know anything. I may be tackling the entire task in the wrong way.
You can use the Filter array to match the items from your trigger and Power Query. Please see below.
Thanks
Share
Report
All responses (
Answers (
