cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jernejp
Level: Powered On

Change Collection column data type

Hi,

I'm fetching data from my database using the Filter function.

There's a column "customer" that is a Boolean type in the database, but in the application I want to change it to String. Is this possible? I've tried searching but came up with nothing.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Change Collection column data type

You can add a column to the filtered results that show the string version of the customer boolean column.

 

Example:

AddColumns(Filter(...), "CustomerStringValue", Text(customer))

 

This creates a new column called "CustomerStringValue" that will have the text value of the customer boolean column.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Change Collection column data type

You can add a column to the filtered results that show the string version of the customer boolean column.

 

Example:

AddColumns(Filter(...), "CustomerStringValue", Text(customer))

 

This creates a new column called "CustomerStringValue" that will have the text value of the customer boolean column.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

jernejp
Level: Powered On

Re: Change Collection column data type

Thank you!

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
Users Online
Currently online: 219 members 4,374 guests
Please welcome our newest community members: