Converter coluna Registro para text formula

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Caros, boa noite!

Estou finalizando um miniprojeto, mas estou com duas dúvidas.

1 - Como converter o valor de uma coluna "registro" para texto dentro da fórmula do powerapps ?

2 - Como acrescentar uma notificação caso o usuário não tenha sido encontrado na tabela usada para o LOOKUP.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sajarac
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

@TheRobRush , sorry bud. Spanish and this is Portuguese. But I can try with my friend google.
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Ah sorry then, I clearly don't know Portuguese when I see it haha 😉 Thanks for checking in though
TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

1) if its a gallery Text(ThisItem.ColumnName)

2)If your lookup return is blank then check https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-showerror
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@renatoromao conseguiria retirar minha dúvida ?
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

For the first question, I think this is incorrect to set an Image control with such a formula. You should tell me what is the , a Person column or other else?

This is not a business of the data type conversion, which needs you convert the value of a "record" column to text. An Image control could only display image value instead of text value.

For the second question, if you want to push a notification if the user was not found in the table used for the LOOKUP, you should set the OnSelect property of the gear icon as below:

If(IsBlank(LookUp(Lista_Inegrantes;Nome_Text=varUser));Navigate(Tela_GerenciarSoliitacoes))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Guys, the solution is...

1 case: add .VALUE in "ThisItem.'Selecione onde deseja desbloquear o fornecedor'.Value"
2 case: f(!IsBlank(LookUp(Lista_Integrantes;Nome_Text =varUser));
Navigate(Tela_GerenciarSolicitacoes);
Notify("Acesso não permitido";NotificationType.Information))