Teams powerapps and dataverse

(0) Share

Report

Posted on by Terry-B

Hey gang,

Looking for a solution here. I have tried everything I could think of (Which is not much, because I am new at this).

I have a dataverse driven canvas app that is basically working up to a basic shipping tracking app. For the most part everything works fine so far. I am using the default Hero form for most of everything in the app.

In a nutshell I want to be able to change the color / border or something of the entries in the Gallery to a specific color(RED) when the specific "Body1" field is empty. the image just shows the Gallery portion of the entire form. The arrow is showing the blanked entry for one specific entry that is blank ( On Purpose). I want a color change to flag that entry to people so they know they have to go into that entry and add whether it is an Import or Export. I have tried controlling the bordercolor, etc with :

If(IsEmpty(Body1),RGBA(100, 0, 0, 1),RGBA(0, 134, 208, 1)) no go. Any thought?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Terry-B,

Is Body1 the name of the column in your Dataverse table? If so, try the following:
If(IsBlank(ThisItem.Body1),RGBA(100, 0, 0, 1),RGBA(0, 134, 208, 1))

You could use a formula such as this on the TemplateFill property of the gallery to shade the background of an item that needs amending.

Hope this helps!

Was this reply helpful? Yes No
Terry-B 73 on at

Like (0)

Report
Copy link

Link copied!

Body1 is the name of the display format for the Gallery. If I am explaining that correctly. the gallery format is title, subtitle, body :
No templatefill in this list:

I have looked for the templatefill property and haven't found it.

Was this reply helpful? Yes No
Terry-B 73 on at

Like (0)

Report
Copy link

Link copied!

ok, so I did find the Templatefill. It appears when the actual gallery is selected. There is code in the templatefill already that slightly greys the Selected record. I would like to keep that affect, but how do I add to it. I trying added the second If statement after a semi-colon, but it doesn't work

Was this reply helpful? Yes No
Terry-B 73 on at

Like (1)

Report
Copy link

Link copied!

Got it :

If(Self.IsSelected,If(IsBlank(Body1),RGBA(100, 0, 0, 1),RGBA(0,0,0,0.05)), If(IsBlank(Body1),RGBA(100, 0, 0, 1),RGBA(0,0,0,0)))

Was this reply helpful? Yes No
Terry-B 73 on at

Like (1)

Report
Copy link

Link copied!

Thank you @Anonymous for pointing me in the right directly. Now onto the next stumblingblock, learning curve item.

Sub-forms for adding new data to a drop-down list if a particular item is not present.

Terry

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Ok thanks @Terry-B, I understand a little better now. Lets build them into one:

Try setting TemplateFill to
If(Self.IsSelected, RGBA(0, 0, 0, 0.05), If(IsBlank(Body1.Text), RGBA(137,25,80,0.05),RGBA(0, 0, 0, 0)))

Was this reply helpful? Yes No