Looking for a way to accurately map between two different data types

Questions
, ,
1

:bullseye: What is your goal?

I’m building a Slack to Monday ticketing workflow. Currently I can read for the ticket submitted in Slack and parse that ticket into text fields that I can map to Monday board. However I’d like to be able to match the user submitting in Slack to the user in Monday.

:thinking: What is the problem & what have you tried?

Is there a way to accurately map a text field to a select field, or to compare a text field to identify a matching select data option to the mapped to the Monday module?
I tried the Get User Module for Monday but I found there wasn’t any way to correctly identify the user from any of the text. I tried a dropdown in Slack in the hopes that it would provide a like for like comparison but it still registers as text when the scenario gets the ticket.

:clipboard: Error messages or input/output bundles

RuntimeError
[200] Request id: f5a3c47d-0495-9b03-a122-d26593e29185
invalid value, please check our API documentation for the correct data structure for this column. Changing column values (ColumnValueException)
Path: [“create_item”]
Status code: 200
Error details: {“column_type”:“multiple-person”,“column_id”:“person”,“column_value”:“{"personsAndTeams" => [{"id" => "Tim Abbot-Cole", "kind" => "person"}]}”,“column_validation_error_code”:“”,“column_name”:“Owner”}

:link: Create public scenario page

3

Hey Tim,

you can add a dictionary in a data store (or a board on Monday) where you link the Monday user IDs to the Slack user IDs. Then search that to find the correct user.

4

Have tried it out and tested it, this works thank you