Unanswered

How to change format of lookup column to string

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No