You’re offline. This is a read only version of the page.
Hi, Everyone!
I wanted to use the chosen Approver in Microsoft Forms and use it as the lookup value in my list to get the email address of the approver from a list of Enrolled Approvers.
Microsoft Forms
List of Enrolled Approvers
Primary List
Power Automate - My flows
The error tells me that the input is invalid since it is in a string format and that the lookup column is in an integer (which I did not remember setting).
How do I change the format of the lookup column and allow inputs that are in sting formats?
I would appreciate any help as I am fairly new to Power Automate, SharePoint and all.
Thank you so much!
Hi @janlisondra ,
You could initialize three integer variables to store the filtered item IDs respectively.
Store the filtered item IDs in the three Apply to each.
Configure the Create item action in the last step, and then configure three variables in this action.
Hope that makes sense.
Best Regards,
Hi Barry,
Since the info of all three approver names will come from the same form, what is the best practice for this? Shall I create the following series of actions?
1) 1st Approver - Create Item
2) 2nd Approver - Update Item
3) 3rd Approver - Update Item 2
Is there a workaround that I can just retrieve 3 IDs and input them in their respective lookup columns in one Create Item action?
Thanks,
Jan Lisondra
Hi @janlisondra ,
Similarly, you can use the same method to get other approver emails. Then in the following steps, use Update item to update the item just created. When configuring the Update item action, only the updated field value is configured.
You may need to initialize an integer variable to store the ID of the newly created item, and use the Set variable action under the Create item action to store the item ID.
Hope that makes sense.
Best Regards,
Thanks, Barry, for responding.
I got this running for the first approver. How shall I repeat the same for the next two approvers?
Best Regards,
Jan Lisondra
Hi @Anonymous ,
You need to filter the corresponding item in the lookup list first, and then fill the item ID contained in the item into the lookup field.
When configuring Filter Query, you need to get the internal name of the field first. You can go to the settings to get the internal name of the field.
Best Regards,
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
