cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Need help with customized form

I all,

I need help (again).  I'm working on a customized form that is linked to a SPO list (obviously).  In the form, I have a gallery, where, if a person is putting in a new entry, can make a list if items to be included in that entry.  The problem I have now, is how to populate the gallery in the customized form when someone clicks on/opens an existing item in the list.  I've tried to use ThisItem.<whatever> in the default values of the gallery, but it doesn't seem to be doing the job.  Any ideas how I can make this work?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Need help with customized form

OK, so, I was never able to get this to work properly.  Didn't get a lot of support on it either.  I did in the beginning, but then, nothing.  I ended up creating a separate SPO list for the items and tying it with the request list via a request ID column.  Not my ideal solution, but at least it works.

View solution in original post

29 REPLIES 29

Re: Need help with customized form

Just wanted to give some more detail on this problem.

 

When a user submits a new request (or creates a new item in the list), they type text into 3 text input boxes that live in a gallery.  When they fill out the 3 boxes in the line and click Save, the line is concatenated (with a "|" in between each) and saved to a collection.  The output of the collection is collected by the datacard value property.  A quick example:

 

You have 3 text boxed in a single line/entry of the gallery:

 

ITEM          DESCRIPTION          QUANTITY

 

The user enters the first line, and clicks the Save icon...

 

ITEM          DESCRIPTION          QUANTITY

PC              Dell                          1

 

The user enters a second line, and clicks the Save icon...

 

ITEM          DESCRIPTION          QUANTITY

PC              Dell                          1

MAC          Apple                       2

 

The collection (and the datacard value) look like this...

 

PC|Dell|1

MAC|Apple|2

 

The user submits the form, and the above is save in the list's Item Detail column.

 

This is all fine if all I care about are new entries, but I'd like a user to see the item details when they open an item in the list.  So, I need to de-concatenate the item's Item Detail record/field and somehow assign it as the default value of the appropriate text box within the gallery.  To compound the issue, there maybe multiple lines in the record (as shown in the above example).  I hope that clears up any questions, but if anyone has questions or comments, please speak up.

 

Thanks.

 

 

 

 

ZePowerDiver
Level 8

Re: Need help with customized form

Hoping this can help you out:

 

I've built what I think is similar in my debug app to see how to deconcatenate your text. So the main field where data is updated is named DataCardValue5

 

I have the 3 text fields used for data entry where the default value is set as follow:

  • Left(DataCardValue5.Text,Find("|",DataCardValue5.Text)-1)
  • Mid(DataCardValue5.Text,Find("|",DataCardValue5.Text)+1,Find("|",Mid(DataCardValue5.Text,Find("|",DataCardValue5.Text)+1))-1)
  • Mid(Mid(DataCardValue5.Text,Find("|",DataCardValue5.Text)+1),Find("|",Mid(DataCardValue5.Text,Find("|",DataCardValue5.Text)+1))+1)

 

Try it and see if it works out as you want.

 

Re: Need help with customized form

Powerdiver, thanks for the reply.

 

I think this would work if I had the information handy in a collection, but it's coming from a record in a list.  The concept I'm struggling with is, when a user opens an item, how do I capture the data in the item?  How can I grab that record, so I can massage the data?  Another question, how do I set it so that it doesn't try to do all this when a person is creating a new item?

ZePowerDiver
Level 8

Re: Need help with customized form

The example I provided was done with a SharePoint list as a source, not a Collection and it updates back to the database. Created in my app to be able to answer your question..

Re: Need help with customized form

Oh, ok.  Perhaps I implemented it wrong.  Where in the app did you put those lines?  In the Onstart?

Re: Need help with customized form

Powerdiver, Ok, I've played with it, and used your syntax (which I believe is correct), but it's not working for some reason. So, an item in the list has an ItemDetail column value of "PC|Dell|1". In the Default property of the Item textbox in the gallery, I put: Left(ItemDetailValue.Text,Find("|",ItemDetailValue.Text)-1) When I save and publish to SPO, then click on an item, nothing shows up in the Item value. What makes this even weirder, is that it DID work, but then stopped working. Don't know what I did wrong, or if I'm doing something wrong. What are your thoughts? Btw, ItemDetailValue is the datacard value in the form.
ZePowerDiver
Level 8

Re: Need help with customized form

Sometimes with those weird characters, based on your PC language / locale it may have issues.. just for the "heck" of it have you tried with an asterisk ?

Re: Need help with customized form

Nope.  Doesn't work either.  Maybe I'm approaching this all wrong.  When a user enters item details (for one or many items) into a gallery, I am taking the row(s) from the gallery and making them a multi-line text record in the list.  When a user opens an item, I need to reverse the process.  In researching this, I did find that the opposite of Concat is Split.  My coworker (who knows a lot more than me) said that to reverse what is saved to the multi-line record, I need to first use Split to get rid of the carriage returns (or Char(13)).  I tried:

 

Split(ItemDetailValue.Text, Char(13))

 

but I get:

 

The property expects Text value, but this rule produces incompatible Table values.

 

I tried just using the code you, Powerdiver, suggested.  

 

Left(ItemDetailValue.Text, Find("*", ItemDetailValue.Text))

 

Nothing shows up (like I said before, this DID work earlier).

 

I am starting to wonder if this is even possible...

ZePowerDiver
Level 8

Re: Need help with customized form

The Split function returns a table of substring, that is why you get this error.

Yes, the fact that you work with a multi line does bring the crlf issue.

Why don't you use 3 different fields to work this out instead of the multiline ?

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 424 members 5,437 guests
Please welcome our newest community members: