Share
Report
12Step 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.
Categories:
I have the same question (0)
All responses (
Answers (
