Unanswered

Convert Lookup Column value as a string in order to use in Power Automate

(0) Share

Report

Posted on by samoIT

I'm trying to use the "Set a Reminder" template for my SharePoint list. I had no issues with this working until I changed the Title column to be a Lookup Column. Power Automate is telling me this column type is not supported. Is there anyway to convert the column's value to a string in order for it to be used in my flow?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

HI , @samoIT
According to your description, i seach the "Set a Reminder" template, but i can not got it .. But if you want to convert the LookUp column to a string in SharePoint list , you can refer to this flow and this is my test sharePoint list :
As we can see the run history for the get items:
So we can use this to get the each loop lookup Value to string.
items('Apply_to_each')?['Plant']?['Value']

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @samoIT

Alternatively, you could directly query on lookup column in 'Get items' action:

LookupCol/Title eq 'new 1'

Pls replace LookupCol with the actual lookup column name. I have used this name as an example, so the syntax will be:

lookupcolname/Title eq 'value'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No