How to extract values from a comma separated field in sharepoint list and how to load that values to dataverse by dataflow in powerapps
@Abhijith123, You can use the Power Query within the Dataflows configuration to split the column with values that contain values with commas:
Once you have the separated columns, you can load them into a new dataverse table or existing one.
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.
Splitting is fine but how do I load that data into a same column in the dataverse table
@Abhijith123, what is the datatype of the column that you are trying to load the data into in Dataverse?
I think I have the same problem. Trying to load them into a multiselect column in Dataverse. Going from SharePoint multiselect to Dataverse multiselect using dataflow.
User | Count |
---|---|
20 | |
11 | |
8 | |
5 | |
5 |
User | Count |
---|---|
31 | |
30 | |
17 | |
14 | |
7 |