Hi,
I am creating a flow where I eventually have to create an item in a Sharepoint list. I have two columns to populate, one is a String and the other a Person column (that I renamed Compte).
When the list is hardcoded in Create item (chosen manually), I can pass Display Name (dynamic field from Get user profil (v2)) to the first column and then the UPN (from Get user profil also) to the person column. Flow works and item is created with the person column populated.
The problem is when I try to give Create item a dynamic field for the list. When I do that, I have to give the json format of the items to modify :
{
"Title": "outputs('Get _user_profile_(V2)')?['body/displayName']"
"Compte": "i:0#.f|membership|bob@myorg.com"
}
I tried to
- concatenate i:0#.f|membership| with a dynamic value for the email
- hardcode i:0#.f|membership|bob@myorg.com
- put Claims from Resolve person
- hardcode the email alone
- email alone but dynamic
- think I even tried putting the ID
I always get a bad request :
"status": 400,
"message": "User value is invalid.\r\nclientRequestId: 6971a48d-dcd3-493b-9c55-f0e8d433e8f2\r\nserviceRequestId: a72052a1-0026-6000-4621-69316bffbe33"
I canno't wrap my head around why it does not work. AI made me try an Http request to sharepoint to patch the data, but it seems not authorized in my organization.
I get the same problem if I want to update the item created.
Anybody knows why and can help ?
Thank you so very much !
4
Share
Report
All responses (
Answers (
