Gallery with on prem sql data source issue

(0) Share

Report

Posted on by EricC

181

Hi All,

Running into an issue when I have a gallery with source

Filter('[dbo].[clientdata]', ClientIDInputbox.Text in ClientID)

That part works fine, I enter the client ID in the ClientIDInputbox and the gallery is filtered based on that clientID.

The issue I'm having is I have a flow that retrieves some info from this gallery such as client responsible, client name and client office which are text labels, but the flow fails with the error invalid value for parameter.

The issue is it thinks the fields are blank because if I use a text label to display data from that gallery such as

Text = ClientName

Text = ClientName.text

The text label is just blank, thus I cannot pull the data from the gallery into my flow. This worked flawlessly last month and I have not changed anything in the app or my data sources/connections.

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
What is your ccurrent situation?

Would you please let me know your Flow configuration, and the value you are trying to put within it?

Besides, could you please share more details about your data source, s[pecially for the field type?

Within the DataCard control of the galley, please consider switch the Text property of Label control to:

ThisItem.Columname

For the Flow.run()， make sure you use the Gallery.Selected.ClientName as the Value input, after that, check to see if it would work.

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

EricC 181 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-micsh-msft ,

I had a call with Microsoft Tech Support on this issue and they confirmed it's a known bug and there is no ETA on the fix.

They suggested to use a list or a collection as a workaround in the meantime instead of a gallery.

Was this reply helpful? Yes No