Skip to main content

Populate "People" column value using users emails

  • February 7, 2022
  • 7 replies
  • 2088 views

Background: We have integration which creates an item on the Monday board when action is created in our platform. It is using Graph QL API to achieve this.

Use case: We want to populate people columns on the Monday with created by and assigned to users but we know only emails of these users.

Problem: According to documentation the user ids should be provided to be able to populate “people” column value. https://api.developer.monday.com/docs/people

The apps framework docs say that you can populate people fields by providing only emais. https://apps.developer.monday.com/docs/dynamic-mapping#examples-of-each-field-type

Is there way to populate “People” column value by posting only user email?

This topic has been closed for replies.

7 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • February 10, 2022

Hello @Severyn!

The people column must be populated using the user’s ID when doing so via API.

The second link you sent is the article about item mapping. For item mapping, we are using monday’s “create item with mapping” workflow block, which uses email addresses.

Hope it helps!

Cheers,
Matias


  • Author
  • Participating Frequently
  • February 10, 2022

@Matias.Monday I see. Thanks


MHaigh
  • monday.com Partner
  • February 14, 2022

Hi, we also would like to be able to populate a person column using the Email… MONDAY DEV TEAM… is there anyway you could enable this… this would be so good to add have an automation that takes the email from a text field on a Form and push this to a PERSON column !!! Please, this should be a fairly simple addition and would REALLY help! (we also want to do it via the API, and I think will have to build a separate lookup table to do this currently). Thanks.


  • New Participant
  • February 15, 2022

We use the VLOOKUP Auto-link Editor app to populate people columns based on email addresses. You have to setup & maintain a table of users, but it allows for the people columns to be populated based on a email addresses provided in a text field on a form.


MHaigh
  • monday.com Partner
  • February 15, 2022

Thanks Kristine - that is my fallback option, but with 600+staff I’m hoping to avoid the lookup table option and be able to use the Monday account directly to avoid the overhead of managing the lookup table.


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • February 16, 2022

Hello @MHaigh!

I have passed this feedback to our team. This is a feature that has been requested in the past and that is being reviewed, so I have added your vote and comment to it 🙂

Having said that, I do not have an ETA on this, so I would not count on it being implemented in the nearest future.

Cheers,
Matias


  • February 23, 2022

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.