Forum Discussion
Lists and forms, populate data and flow
sarahtransistor you can certainly do this except for the Forms part as in Microsoft Forms it's not possible to pre-populate anything in Forms. Instead use an approval flow in Power Automate:
1. In the flow trigger select custom value and paste in your list address then select your list name:
2. Add a get changes for an item or a file (properties only) action. For the Since field you can either select Trigger Window Start Token or turn on list versioning for your list and add the following expression into the Expression tab of the dynamic content box:
sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
3. Add a condition and in the left field select Has Column Changed: Current owner is equal to true. Leave the red if no channel empty.
4. In the green if yes channel add a start and wait for an approval action as follows. Make sure that Current Owner Email is selected for the Assigned to field.
In this example I added myself as the current owner.
The first time you run this it takes a few minutes to trigger but then the current owner receives the following adaptive card email where they just select their response, add any comments and click submit. The adaptive card then closes and displays their response, which means they can only do this once.
You could add follow-on actions to record their response, response date and comments in your list. But this is probably enough for now to get you started.
Rob
Los Gallardos
Microsoft Power Automate Community Super User