You’re offline. This is a read only version of the page.
Hi, I'm currently building a flow that creates a column named "Assigned To" using an HTTP request. The column is being created but when I try to add a row with a user (using email), it shows up as blank. There are no errors but nothing shows up. Here are screenshots:
Create field:
Add row:
DMTM Email is just a string that contains an email address. Is the ""Assigned_x0020_To": {result: '@{outputs('Get_new_item')?['body/DMTM/Email']}'}" line incorrect?
Thank you,
Arthur
Hi @RMD211,
If that is the response you are getting to check for the loginName it means it was not able to find the correct user.
But like mentioned earlier. That additional HTTP request is not really required, it is only to validate when you are unsure.
Normally you could just use the i:0#.f|membership|emailaddress syntax for the LoginName value (when it is an internal user) with the validateupdatelistitem method. Did you try that approach first?
Hi! I'm trying to use your solution above - but my Send http request is showing like this. Any ideas how to get results and therefore the LoginName back from this?
Hi @Anonymous,
Typically that would just be i:0#.f|membership|emailaddress
If your really want to be sure you could retrieve that via another request. You can use the SiteUsers endpoint and retrieve the LoginName property.
Share
Report
All responses (
Answers (_api/Web/SiteUsers?$filter=Email eq '@{variables('EmailAddress')}'&$select=LoginName
You can retrieve the first value via this expression:
outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Claim')?['body']['d']['results'][0]['LoginName']
Thanks @Expiscornovus for answering!
How do you obtain the user key and membership? I just have their email address.
Thanks,
Arthur
Hi @Anonymous,
You could use the ValidateUpdateListItem method for this. With this method you can use the key and the user claim to update the person field. A user claim would be something like this i:0#.f|membership|janedoe@contoso.onmicrosoft.com
{
"formValues":[
{
"FieldName": "Assigned_x0020_To",
"FieldValue": "[{'Key':'@{variables('UserClaim')}'}]"
}
]
}
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
