web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How I can use Set vari...

Power Apps

Answered

How I can use Set variable from lookup?

(0) Share

Report

Report

Posted on by mmxupp

Set(varLookup,

If(IsBlank(LookUp('list_sharepoint', No = Value(DataCardValue39.Text),'Column')),

"f",

LookUp('list_sharepoint', No = Value(DataCardValue39.Text),'Column')));

I want to convert type of varLookup to Text.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mmxupp,
What is the type of 'Column' in your list?

Best Regards,
Kyrie

Was this reply helpful? Yes No
mmxupp on at

Like (0)

Report
Copy link

Link copied!

@v-mingkz-msft Text

Was this reply helpful? Yes No
Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@mmxupp,

Set(varLookup, If(IsBlank(LookUp('list_sharepoint', No = Value(DataCardValue39.Text),'Column')), "f", LookUp('list_sharepoint', No = Value(DataCardValue39.Text),'Column'))));

I did some test according to your description.
You should be missing a parenthesis at the end of your expression and the varLookup will be text type.

Was this reply helpful? Yes No

Join the conversation