Hi All
Not sure what to do here been trying for hours.
I have a Sharepoint list where I have a Single line text column named Workspace sending a URL Link to my Power App, I then have a button in my power app that is supposed to launch the URL contained in 'Workspace' that has the following code.
OnSelect = Launch(ThisItem.Workspace)
When ever the button launches however it adds %E2%80%8B to the end of the URL causing an error .
When I put ThisItem.Workspace in a label this does not show the %E2%80%8B as Text?? Highly Confused
Solved! Go to Solution.
In SharePoint Column
U+200B | | e2 80 8b | ZERO WIDTH SPACE |
There is something wrong with the SharePoint List Column Value of the specific row (record) in the SharePoint list data, there is probably invisible data at end of the URL in that record.
Can you copy and paste the URL into Notepad, then copy and paste it into a brand new SharePoint List record (from SharePoint), use that new record from PowerApps, and see if it helps resolve this one?
"ThisItem.Workspace"
What is this referring to? A column you made in the SharePoint list?
Please provide more detail.
Hey I updated my main message but yes Workspace is the column in my sharepoint list
In SharePoint Column
U+200B | | e2 80 8b | ZERO WIDTH SPACE |
There is something wrong with the SharePoint List Column Value of the specific row (record) in the SharePoint list data, there is probably invisible data at end of the URL in that record.
Can you copy and paste the URL into Notepad, then copy and paste it into a brand new SharePoint List record (from SharePoint), use that new record from PowerApps, and see if it helps resolve this one?
Hi @unislacker ,
Could you please share a bit more about the Workspace field in your SP List? Is it a Single Text type column?
I have made a test on my side, and don't have the issue that you mentioned. Please consider modify your formula as below:
Launch(Substitute(ThisItem.Workspace, "%E2%80%8B", ""))
Please make sure the Workspace field is actually a Text type column in your SP List. Also please consider create a new "Hyperlink" type column in your SP List, then use the "Hyperlink" column to store the URL info, then check if the issue is solved.
In addition, please also check if each Workspace field value in your Gallery would cause same issue.
Best regards,
This also worked for me with a similar issue in SharePoint. A button linked to another SharePoint page was not working, but after copy-pasting the name from notepad, it worked!
User | Count |
---|---|
197 | |
122 | |
89 | |
48 | |
41 |
User | Count |
---|---|
286 | |
162 | |
138 | |
80 | |
73 |