Answered

Invalid URL (email) in a form connected to SharePoint List

(0) Share

Report

Posted on by JohanSmith-07

Hi all,

I have a button aiming to save data captured using a form within Powerapps and send it into a SharePoint List, one of the DataCards of my form is the email address of the user, I have the following formula:

User().Email

The format of the DataCard is text but is storing an email (which I think is Hyperlink format)

In my buttom action I have the following formula, aiming to create a new item in my sharepoint list

SubmitForm('FSE Process Form')

This gave me the following error:

Invalid URL.png

My Sharepoint list column is formatted as Hyperlink

SP list Column format.png

How could I solve this? any idea would be highly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Gochix 1,937 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @JohanSmith-07 ,

The answer is right in front of you.
The column Responsible in the SharePoint is expecting a hyperlink or a Picture.

You are trying to save it as email address.
Just change the column to single line of text.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
JohanSmith-07 59 on at

Like (1)

Report
Copy link

Link copied!

Thank you @Gochix , I changed my SP list field format to text and now it works

Was this reply helpful? Yes No