Filenames being written to muti line fields

(0) Share

Report

Posted on by Lefty

1,625

Hi @RandyHayes

Thought it was better to log a new question.

I have as you know I am allowing a maximum of 4 pictures to be stored in a collection. Each image has its own description muti line text field from SPO list.

Picture1.jpg a user would enter text in Picture1 description field Picture2.jpg in Picture 2 description etc, but when a user deletes Picture1.jpg and the next available value to be used in naming the pictures would be Picture5.jpg, it then means there is no link between the picture and the field.

I thought I would just name all the 4 description fields, Picture description (as they will appear below each picture anyways), and in the text area somehow get the name of the image pre-populated (of course if i did this, I would then need for it to delete the value if the picture was deleted, so maybe is not the best approach).

At the least I should hide the description fields and only make them visible if a corresponding picture is added.

I.e. Picture1.jpg and Picture2.jpg have been added - so only show 2 description fields, and not 4, hope this makes sense?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Lefty

I am not entirely sure what you are running into here.

Are you storing the descriptions in separate records, or in separate columns or in the same column?

If it was my approach, I would store the picture name and the description together all in one column and then just split out the name and description when viewing. But, I am not sure exactly what you have so far and how that would fit in.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!

I'm actually not storing the picture name in any column (well I'm pushing the pictures in the attachment control) Hopefully the picture allows me to explain, where I have designed it to appear like the first picture has description below it:

separately, here as you can see I do not have 4 pictures but the 4th description field is still visible tried a few things but couldn't get it to fully work, like it would work if i was viewing a record, but not if was trying to submit a new record or vice versa, but not for both when viewing a submitted record and when trying to submit a new record:

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Lefty

So then I am not entirely clear on what is going on in your app.

As I see it though, you would have a horizontal gallery that is based on the collection of images that you have and also includes a description. You would only have visible those that are populated or that you are adding.

Your attachments is based on the collection you have and you would simply write the description of each image to the appropriate place. That could be in a comma (or other) separated list, or in individual column in your list.

There should always be a one-to-one correlation from each image to the description.

What am I not seeing? How are you storing the information?

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!
@RandyHayes

Yes correct, I have an image and for every image (max 4) I have 4 sepreate SPO list fields, titled Picture1Description - Picture4Description

I guess what I want to do is hide the PictureXDescription field and only make it visible there is a picture for it, so if i have 3 picture, i dont want to display Picture4Description:

I tried something like this on the visible property of Picture1Descrption field but isnt working as expected as it wont show up even VarRecord is active of course i need it to display both when its a new item or when viewing an existing item:
If(!IsBlank(VarRecord.Picture1Description), true, false)

That's the first part of the help I need.

Secondly and I'm not sure if this is possible but it is is, I want to set a default value in each PictureXDescription field when the picture is added to the gallery. I.e. if Picture1.jpg is added to the gallery then in the Picture1Description I'd some how want "Picture1.jpg "
I hope I am explaining what I require a little better?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Lefty

So, I've been going over your scenario from a couple of angles and I have some concerns on how this is set.

1) Can the images always be numbered sequentially?

2) Will users be editing records that have been created with pictures and should see the same images in the exact order or can they be sequentially ordered? In other words, if the first user has a picture for 1, 2 and 4 but not 3, when it is saved, can they be Picture1, 2, 3 or Picture1, 2, 4? Does the sequential number in the name have importance?

3) Can a picture name be changed later? For example if a user edits a records where there is 1, 2, 3 and 4 and they remove 2, can 3 and 4 be renamed to 2 and 3 or must they stay the same?

So basically, I am getting tripped up on your editing scenario. Perhaps you have some rules based on all of that. Surprisingly enough, getting the information the way you want is not so challenging, it's more about understanding HOW you want the rules to go.

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

1) Can the images always be numbered sequentially? I'm using your suggestion from the other post, where if an image is deleted from the gallery, the next available number is then used Picture 1-4, Picture 3 is deleted, the next available number it will use is Picture 5.

2) Will users be editing records that have been created with pictures and should see the same images in the exact order or can they be sequentially ordered? In other words, if the first user has a picture for 1, 2 and 4 but not 3, when it is saved, can they be Picture1, 2, 3 or Picture1, 2, 4? Does the sequential number in the name have importance?
Users are not being allowed to make changes to a submitted record, they can only view the record and pictures in view mode.

3) Can a picture name be changed later? For example if a user edits a records where there is 1, 2, 3 and 4 and they remove 2, can 3 and 4 be renamed to 2 and 3 or must they stay the same?
Again same as above, they will not have the option to edit a record

Was this reply helpful? Yes No