Populate a dropdown list from a web service output

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi @v-micsh-msft is this something you can help me with?

I am doing an experiment where the items for a dropdown box as stored as string... ie

"ItemA, Item B, Item C"

I need to convert them to table format (ie ["ItemA", "itemB", "ItemC"]. I have not found a way to do this inside PowerApps. So having played around with making my own webservices, I decided to do something really crazy and make a Flow that converts a string to a JSON array.

I did this via setting up Flow to be triggered from a Request trigger and I send a response action back. I then made a swagger file for PowerApps to consume and registered the custom connector.

When I call this webservice outside of PA, flow returns an array...

I then tried this:

Set(blah,StringtoJSON.StringtoJSON("AA,BB,CC"))

The net result of this was that my variable "Blah" was seen by PowerApps as a table, but it was empty.

So my question is twofold. First, can I dnamically generate a table for a dropdown to consume inside PowerApps? Second, if you put aside the fact my workaround is pretty insane and I'd likely not do it in prod, nevertheless can you see a reason why PA would be getting an empty value?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Would the table() function helps here?

Table function in PowerApps

For example, to have the itemA itemB itemC stores in a table, we could try the following:

Table({Value:"Item A"},{Value:"Item B"},{Value:"Item C"})

For function which would convert several strings into a single column table, based on what I know, that is not available under PowerApps.

There is an idea submitted on this:

Function to split a string into a table with results

Besides, for the table get from the Flow, take a try to click the Grid under the table.

The single column should be archived there.

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

A table function works, but I have not found a way to be able to pass a variable to it - ie a string. In this case the list of dropdown items is coming from a SharePoint list...

Make sense?

Was this reply helpful? Yes No
Ed_M 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Any luck on getting this to work? I'm looking to do something similiar with a webservice; for the purpose of processing business logic and returning a string on my powerapps.

Was this reply helpful? Yes No