How to display a text from the Dataverse?

(0) Share

Report

Posted on by Lenders18

Hello,

I am developing an application to evaluate questions.

I use the dataverse for that.

This is my application:

I would like that when I click on the icon in red, to display in a label the "LEVEL DESCRIPTION" of my Level table, according to the icon of the question.

Can you help me? I have been stuck for 10 days.

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Lenders18 ,

I cannot figure it out the relation between Table Question and the gallery from your application, but i'm sure that is one. So I supposed that the gallery is a filter of table Question.

Based on this:

In gallery you should use a radio control with the following properties:

Items: Filter(Level,'QUESTION ID'=ThisItem.ID).LEVEL Color: White Hover Color: White Size: 1 Layout: Layout.Horizontal

and about the icon, for a better user experience, you should use the tooltip properties with:

LookUp(Level,'QUESTION ID'=ThisItem.ID && LEVEL = RadioControl.Selected.Value,'Level Description')

Hope it helps !
Lenders18 73 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Gabibaban,

I have an error message :

"Incompatible type for comparison. It is possible to compare these types: Text; Number"

Code with real column names :

When i clic on my radio :

"Error while trying to retrieve data from network"
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Lenders18 ,

Try this:

With({selectedLevel:Text(Radio_lvl_Choice.Selected.Value)}; LookUp(Level;Question.ID=ThisItem.ID && Level_Name=selectedLevel;'Description FR') )
Lenders18 73 on at

Like
a
(0)

Report
Copy link

Link copied!
it works but i have a problem @gabibalaban .

Items :

Filter(Level;Questions.ID = ThisItem.ID).Level_Name

Tooltip :

With( {selectedLevel: Text(Radio_Lvl_Choice.Selected.Level_Name)}; LookUp( Level; Questions.ID = ThisItem.ID && Level_Name = selectedLevel; 'Description FR' ) )

The value of my radio, it should show the "Value" not the Level_Name.

My table on dataverse :

AND I also need to display the value in order.
1, 2, 3 4
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Lenders18 ,

If noticed a small mistake in my formula (yours works fine as well).

With({selectedLevel:Text(Radio_lvl_Choice.Selected.Value)}; LookUp(Level;Question.ID=ThisItem.ID && Value=selectedLevel;'Description FR') )

The radio items will be in this case:

Sort(Filter(Level;Questions.ID = ThisItem.ID),Value,Ascending).Value

For a friendly UI , I recommend to set Size to 1 and color to White to obtain something like:

Hope it helps!
Lenders18 73 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban

It doesn't work anymore.
Tooltip :

Items :

When i clic on my radio :

"Error while trying to retrieve data from network"

Do you have an idea ?
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hmm … there is something I miss.

Let’s go back to your working formulas:

items:

Sort(Filter(Level;Questions.ID = ThisItem.ID);Level_Name;SortOrder.Ascending).Level_Name

Tooltip:

With( {selectedLevel: Text(Radio_Lvl_Choice.Selected.Level_Name)}; LookUp( Level; Questions.ID = ThisItem.ID && Level_Name = selectedLevel; 'Description FR' ) )
Verified answer

Lenders18 73 on at

Like
a
(0)

Report
Copy link

Link copied!
I founded the solution @gabibalaban

I replaced in tooltip with this:
With( {selectedLevel: Text(Radio_Lvl_Choice.Selected.Value)}; First(Filter( Level; Questions.ID = ThisItem.ID;Text(Value)=selectedLevel)).'Description FR' )

I think you were right. but in the syntax we compare Text with an integer.

Thank you very much for your help 🙂