crypted data in power apps

(0) Share

Report

Posted on by gikido

1,032

Hello everyone,

I have a Canvas application and my database is SQL Server. Among these tables, there are some columns where the data is encrypted, and I would like to display them in the application in a decrypted format.

How can I do this?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@gikido,

Power Apps has no decryption capability.

You would need to do this in SQL either as a View or Stored Procedure.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
gikido 1,032 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you for your response

Could you please provide more details? If we use views, does that mean the data will be displayed directly at the database level? And

regarding stored procedures, how can we use them?

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@gikido,

Both access the data directly, however a stored procedure is generally more flexible - this video should be a good start and this one also.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gikido,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No