cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PoohBear
Level 8

Help with converting Collection field to Text

I am creating a collection from a MySQL table and adding a column with is converting a number field to text. I am trying to reference that field in a SharePoint form, but it keeps coming back that it is expecting a Text value and this is a table value. I setting a variable with that field, but I keep getting the same error. Any help is greatly appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
PoohBear
Level 8

Re: Help with converting Collection field to Text

I found a workaround. Might not be the best way to go but it works. The collection is only bringing in the last row of the table because I need to auto populate the next id value. So I am using a dropdown control to store the record. The text value is referencing the "dropdown.selected.value" +1.  

View solution in original post

1 REPLY 1
PoohBear
Level 8

Re: Help with converting Collection field to Text

I found a workaround. Might not be the best way to go but it works. The collection is only bringing in the last row of the table because I need to auto populate the next id value. So I am using a dropdown control to store the record. The text value is referencing the "dropdown.selected.value" +1.  

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,736)