cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How can I clear a Sharepoint list Hyperlink column from Power Automate

I have searched and not found a solution to my issue.  I am stumped on how to set the value of a Hyperlink column to be blank.  The situation is we have a list that contains project information.  One column is a link to another system where the PMO team uses to manage projects which are set when the users update the ProjectID column.  Once the ProjectID is updated, the flow will populate several columns for reporting which includes the URL to the project in the management application.  In my flow, I need to be able to clear this Hyperlink column from the URL that is currently in the column and be blank.  The situation I need to handle is when someone enters the incorrect ProjectID and will come back and clear the ProjectID field, the flow is failing when the update occurs.  I am getting the error 'ProjectURL' is required to be of type 'String/uri'.  I tried to update with a null value as well as an empty string variable.

 

I would appreciate any guidance on this.  Otherwise, I may be forced to use a bogus URL.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

Well, I have found a solution to address this issue.  This is for anyone who may have a similar problem.  I used the following expression in the Update Item action for the HyperLink column.

 

if(not(empty(variables('your variable name'))),variables('your variable name'),null)
 
You just need to confirm the variable has the data that you want to update the column to. Otherwise, the column is updated to null.
 
 
 

View solution in original post

10 REPLIES 10
Resident Rockstar
Resident Rockstar

Just tested this. I get the same behaviour. But if you use the expression "null" it works fine. Don't type null in, use the expression null.

ExpressionNull.PNG

Thanks for the quick response.  I failed to mention there is an email notification that is sent to the users notifying them of changes made to the project for reporting purposes. This flow is triggered on the List item being modified.  I am using variables that are set based on the column that is changed.  I tried to set the variable to null as well and still got the error.  My only thought is I will need to have a conditional prior and have different Update Item actions.  My goal was to not have an Update for each change which would trigger the flow to run again and the user receiving several emails on the changes.

 

phanks01_0-1605711221353.png

 

Solution Supplier
Solution Supplier

@phanks01 , on your variable, assign the string value "@null", that will null the value of the url.

It does not change the error.  I have tried the value @null, "@null", and the expression null.  All give an error.  The only value that will not error is a valid URI formatted string such as http://nourl.

 

phanks01_0-1605793441224.pngphanks01_1-1605793449270.png

 

phanks01_2-1605793464236.pngphanks01_3-1605793472098.png

 

phanks01_4-1605793486038.png

phanks01_5-1605793494341.png

 

I did additional testing today and discovered the code behind the flow is not what I assumed it would be.  For example when I use the expression null in the Update Item action the code inputs "@null".

 

phanks01_5-1605821451247.png

 

phanks01_0-1605821101853.png

 

However, when using the action Set Var with the Expression null, it places "@{null}".

phanks01_1-1605821167570.png

phanks01_2-1605821181071.png

 

When I do the same but input the value as @null.  what is input is "@@null".

phanks01_3-1605821280375.png

phanks01_4-1605821289627.png

 

I am confused as to how to get the variable to work for the Hyperlink values.  For normal string values it is not a problem.

 

 

Frequent Visitor

Does anyone have a suggestion for this?  Or is this a bug?

Resident Rockstar
Resident Rockstar

I'm really curious to find out why it does not work for you. On my tenant it just did it, right away. Simples. No variables, no messing around examining code. Expression -> Null -> Done.

When you find out it would be good if you shared.

If I do not use variables it will work.  However, I need to use the variables as the flow is checking several of the columns that may need to be updated and issuing one update action with the variables.  The issue is when there was a value in the column and I need to remove that value.  Can you do a peek at the code and see what is actually being defined? 

Frequent Visitor

Being that I need to use variables, is there anyone that can provide a direction to help me address this issue?

Frequent Visitor

Well, I have found a solution to address this issue.  This is for anyone who may have a similar problem.  I used the following expression in the Update Item action for the HyperLink column.

 

if(not(empty(variables('your variable name'))),variables('your variable name'),null)
 
You just need to confirm the variable has the data that you want to update the column to. Otherwise, the column is updated to null.
 
 
 

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (4,466)