Copying a Sharepoint User/Group column to plain text

(0) Share

Report

Posted on by Fernanda

380

Hello!

I am building an App and I am having delegation problems with a filter that contains data from a User/Group column in my Sharepoint data base. This column is specifically .Department.

I have been reading about it and it says that a simple solution would be to create a column right next to it with the same info, but connverted to text and Automate could help me do that.

I am not very familiar with power automate, and even though I was looking at how I could build up the flow, I just got completely lost.

Error from powerapps

This is the configuration of my column in Sharepoint (User/Group; Department as shown field)

I looked at possible solutions, but most of them were to update a different sharepoint and not the very same one once that field is completed

Could you please help me?

Thank you in advance!!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (2)

Report

@Fernanda

You need to have a new flow that runs manually and list all rows in the sharepoint list , add an apply to each loop and update item action as below:

Then to update the text column from the department you can update your text field from the department field of the Group Column

Was this reply helpful? Yes No
Fernanda 380 on at

Like (0)

Report

Hi!!!
Thanks so much! it worked!
I have a question though. This flow can't be set to work automatically??

Was this reply helpful? Yes No
askondo on at

Like (0)

Report

@Mira_Ghaly Thank you very much for all your answers to the forum.

Was this reply helpful? Yes No