Skip to main content
Solved

sharepoint list writer

  • November 13, 2020
  • 4 replies
  • 93 views

totobobiasos
Forum|alt.badge.img

I'm having trouble writing sharepoint users to a sharepoint list. It does not seem to matter how I'm formatting the user string attribute - it just wont accept it.

 

The writer is configured as uploaded workspace. The sharepoint list adds a new, empty row.

 

 

HOW do I configure the writer, and what is supposed to be the correct attribute value?

To my understanding, the attribute value is to be formatted as

i:0#.f|membership|name.name@domain.se

Best answer by andreaatsafe

Hi @totobobiasos​ ,

Have you tried setting the attribute value to: "FirstName LastName" (no quotes)?

I just did a test and was able to submit if I used the users name rather than how the "account" value is formatted.

I would recommend reading in the SharePoint list to see how the data is displayed in FME and mimic that. Again it should display the user field based on "FirstName LastName".

 

-Andrea

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

andreaatsafe
Safer
Forum|alt.badge.img+14
  • Safer
  • Best Answer
  • November 18, 2020

Hi @totobobiasos​ ,

Have you tried setting the attribute value to: "FirstName LastName" (no quotes)?

I just did a test and was able to submit if I used the users name rather than how the "account" value is formatted.

I would recommend reading in the SharePoint list to see how the data is displayed in FME and mimic that. Again it should display the user field based on "FirstName LastName".

 

-Andrea


totobobiasos
Forum|alt.badge.img
  • Author
  • November 18, 2020

Hi @totobobiasos​ ,

Have you tried setting the attribute value to: "FirstName LastName" (no quotes)?

I just did a test and was able to submit if I used the users name rather than how the "account" value is formatted.

I would recommend reading in the SharePoint list to see how the data is displayed in FME and mimic that. Again it should display the user field based on "FirstName LastName".

 

-Andrea

Ah. That simple, huh.

No duplicate management. That's going to complicate things a bit. Hmm.

 

Thanks for the answer! :-)


erivero
Participant
Forum|alt.badge.img+2
  • Participant
  • February 15, 2025

Is it possible to write to a users field that accepts multiple selections?


crystalatsafe
Safer
Forum|alt.badge.img+26

Hi ​@erivero 

Are you asking about a Person column in a list?