cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbsin
Post Prodigy
Post Prodigy

patch and url? need help to patch

 

Hi 

 

Can anyone help.. what is the patch not right?

 

Also I have a URL column in side SP list, how to patch back and show clickable in gallery?  thank you

 

The amount in SP is in currency.  Do I need to change to number?  Thanks

 

bbsin_0-1633684424878.png

 

 

5 REPLIES 5
rampprakash
Super User
Super User

Hello @bbsin,

 

If it is Curreny in BackEnd, and you cannot change the Type of Field in powerapps try using Value(Text).

For Showing URL try Using HTMLtext.

 

Let me know if you need any help.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

1. To show clickable link in Gallery

Insert a HtmlText and Set HtmlText to

"<a style='color:blue' href='" & ThisItem.URLColumn & "'>" & ThisItem.URLColumn & "</a>"

StalinPonnusamy_0-1633699469149.png

2. For Currency, As Ram mentioned needs to convert to value since PowerApps has text

Patch(
    EventIItinerary,
    BrowseGallery1.Selected,
    {
        Cost: Value(DataCardValue15.Text),
        EventLogin: DataCardValue16.Text
        
    }
)

3. To Save back the URL, no special needed. This is just text

EventLogin: DataCardValue16.Text

 

here EventLogin is URL field in Sharepoint

 

Please share the error information if this is not resolved.

 

 

bbsin
Post Prodigy
Post Prodigy

Hi 

 

can help advise what is wrong with the syntax?

bbsin_0-1633848590884.png

 

 

let me try to put in shortly

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

Remove this {Total: Amount.Text} on your patch command and replace with

Total: Value(Amount.Text)

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,656)