Unanswered

Sharepoint calculated column to give as hyperlink

(0) Share

Report

Posted on by Harika_1

Hello Community, I am a Newbie to Power Platform.
I have 2 columns in a SharePoint list.
one column named LRV is a number (with random numbers between 1 to 10)

The 2nd column is a calculated column created by me.
Now, In this Calculated column I need to display an URL depending on the number displayed in the LRV column.

I tried Using an If Condition Where for example, if LRV value 1 then Calculated column should show "https://www.google.com" and so forth. But the issue here is that I'm getting txt value of the instead of a hyperlink.
FYI, I have also tried with the href Tag but didn't work.

Any Kind of Solution or a Work Around is Highly appreciated.

Thanks 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

Hi @Harika_1 ,

Firstly SharePoint calculated columns do not work consistently in Power Apps and should be avoided. I suggest you do the calculation in Power Apps and it should work as expected.

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Harika_1 on at

Like (0)

Report

Hello @WarrenBelz.
Firstly, Thank you for your reply but in my use case I do not have a power apps integrated with it. It is just a SharePoint list with few columns.
Could you please guide me if there is any other work around like using power automate to anything like that.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@Harika_1 ,

This is a Power Apps forum, so I assumed it was about issues there. You are probably better posted on the SharePoint Community.

Was this reply helpful? Yes No