We have a SQL database that get populated with form responses.
The way it has been set up is a little strange.
There are two separate Tables.
One Table consist of Unique ID.
ID, SUBMISSION ID, FORM URL, FORM DATE
1 120 form3.aspx
2 121 form4.aspx
3 122 form300.aspx
Second Table consist of the answers from the form (but in separate rows)
ID SUBMISSION ID QN VALUE
400 120 1 Mrs Smith
401 120 2 Boston
402 120 3 Manager
403 120 4 Message
404 121 1 James
405 121 2 Yes
406 122 1 Sally
407 122 2 I Confirm
So we would need to set the trigger for one table but pull out responses from another table.
Because the response return as multiple rows in the second table, I'm needing to use power query to pivot the table to just have one row per submission.
So on power Query I've done this:
SUBMISSION ID QN1 QN2 QN3 FORM URL
120 Mrs Smith Boston Manager form3.aspx
121 James Yes Form4.aspx
122 Sally I Confirm Form300.aspx
On Power automate, my trigger is when an item is created on a table
My flow looks like this:
Then I need it to create an item on Sharepoint with those details.
How do I limit the power query rows to only show the row from the trigger and not all the other?
Because now, it's just creating multiple items for all rows, over and over again everytime it's triggered.
I hope that makes sense!
This message may contain confidential information. If you are not the intended recipient please inform the sender that you have received the message in error before deleting it. Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.