cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lmcginnis
Helper I
Helper I

How do I save data, concatenate text?

Hi,

I am building an app and need advice on, various things ..

 

1st, the best senario to save my data..

 

Senario,

Datasource = excel table(1)

Purpose, I have an excel sheet that has Site information, name/number/nearest ER/ER directions/ER phone/ etc...

1st page has combobox linked to data table, and I use a reference to it in many lables on other pages to pull up specific information that colleralates to that selection. 

I have pages setup and working that pull from the excel table(1) into lables displayed with the information I am asking from it.

On the following pages I have some text input, radial selections, checkboxes, etc that related to the work being done at the Site.. I need to combine this new information with some information I am pulling from my table currently, and some additional fields in my table into a page so that the data can be reviewed, (all at once, or broken up in sections peferably as my input pages are, scrolling labels I like 🙂

then,

I would then like to have that information saved to a different excel table(2) creating new rows for every entry.

Also to be able to save it locally, be able to reload it for reviewing before submitting, and then upload it to my excel table(2) .. incase there is no internet..

 

 

 

2nd problem,

I cannot seem to get MSN weather working at all using the table information from my combo box, what i have is 2 seperate columns, 1 for lattitude and 1 for longitude, I tried inputing both at the same time, I even created a new column in excel that is =concat(m2,n2) which are those 2 columns and merged them into one named GPS.. tho, i would like a space between them, but cant get that working either.. tried many things, like =concat(m2, "  ", n2) etc .. 

Currently,

 

Set( /* <-- Please use Set function to store the variable instead of UpdateContext function */
Weather,
MSNWeather.CurrentWeather(Concat(ComboBox1_1.SelectedItems, 'GPS'), "Metric").responses.weather.current
);
Navigate('Current Weather', ScreenTransition.None)

 

The button has and X, says invalid argument, expecting text value.. and doesnt work 😞

 

 

Additional help,

I have an msn weather help topic already, and I couldnt get it working.. but as I dive more and more into this I noticed it had a clearcollect, and as I an newb at this. I dont know if it clears all collected data, or just the one it's pointing to.. 

Can you have multiple collects going?

 

Thanks,

Lance <- Less then 1 week using powerapps, no prior experience, please help 🙂

 

Edit by @Mr-Dang-MSFT: renamed title to be more descriptive

 

15 REPLIES 15
Lmcginnis
Helper I
Helper I

Dang I forgot something,

If using collect will work for temporaily saving the information until I export it either local or online, how can I collect autopopulated labels? .. that are pulling information from a combobox linked to an excel table?

 

thanks again,

Lance

Welcome to PowerApps, @Lmcginnis !

 

It looks like there's a few questions here:

  • How do I save data? It sounds like you want to save information about the work done at different sites. Some keywords to search on this forum would include: Patch, new record, SubmitForm,
    • Adding in some folks who can share threads they've answered on saving data: @LRVinNC@timl @RandyHayes 
    • Can you share some screenshots or whiteboarding of what you're trying to achieve?

  • How do I simulate offline experiences?
    • Here's how I do it:
      https://www.youtube.com/watch?v=j30xOM5OmRE
    • Big idea: attempt to save. If there are errors, collect what you were trying to save locally. Upon returning to connection, write all records back to the table. Remove the backed up records as they're successfully written. There's a link to download the example.

  • How do I concatenate text for each row?
    • Concat will concatenate text across a table. So it'll put the content from one row beside the content for the next, and so on. I think in your case, you'll want a helper column--think Excel here.
    • Can you share what your table of lat long looks like? I want to be sure before I suggest something.

 

In the future, as a best practice, I'd separate each question into its own thread. This way you can give each one its own attention and you can have a more descriptive title.

+ @Anonymous 

I don't know much of what you are doing, but here are a couple design issues that I see:

1. If I were the one building this app, I would load the content of the Excel table into a Gallery on my main screen, similar to what I have here:

 

CitiesGallery.png

 

Now, I am not suggesting you abandon the idea of using a combo box as I am not sure what your specific requirements are, but working with galleries are much easier.

 

NOTE: My particular Excel table contains 4 columns: City, State, Latitude, and Longitude

2. When the user clicks on the [>] button to see more details for the selected item, I have set the OnVisible event of the Detail screen to perform the following:

 

Set(
    CityWeather,
    MSNWeather.CurrentWeather(
        BrowseGallery1.Selected.'Latitude ' & "." & BrowseGallery1.Selected.Longitude,
        "Imperial"
    )
)

In this particular case, I have initialized the CityWeather object with the MSNWeather.CurrentWeather() response, passing in the Latitude and Longitude from the selected gallery item. Note that I do not use the Concatenate() function here as it's easier to concatenate text with & operator. Also note that Latitude and Longitude are separated by a period.

I added two fields: one to display the temperature and the other to display the dew point

CityDetails.png

 

The Temperature uses the following formula:

 

// Current Temperature
CityWeather.responses.weather.current.temp

The Dew Point uses the following formula:

 

// Current Dew Point
CityWeather.responses.weather.current.dewPt

Again, to me personally, is a matter of ease of design and implementation and I prefer galleries over combo boxes

 

Also, please remember, it's hard to troubleshoot an app or the code behind it when you don't let us see what you are doing. It helps to post pictures or code blocks to aid the rest of us with providing some guidance.

 

MG.-

Mariano Gomez, MVP

 

Thanks for the mention @Mr-Dang-MSFT!

@Lmcginnis - hopefully, there's plenty here to answer your questions, but feel free to post back if you still have any specific questions. 

Ill work on getting some screen shots, maybe i can duplicate and clear my db and export the app, or just find a share public option to a clean version?

will also work on some of ideas presnted, and when I get sometime ill try to revise my questions into specific functions, that i can apply when needed...
This is a side thing, for saftey that is lacking at my job, im a tower climber, and i just stumbled across this powerapps thing on our office365 account 😕

thanks again for the help.

Here are the pictures of the current version so you can see what I'm doing, ofcourse I am updating the layout and options when i have time.. 

 

Capture1.JPGCapture2.JPGCapture3.JPGCapture4.JPGCapture5.JPGCapture6.JPGCapture7.JPGCapture8.JPGCapture9.JPGCapture10.JPGCapture11.JPG

Update on trying to resolve weather issue,

I altered your suggestion thinking I can do it from the data I have been using, but it didnt work.

 

Set(
SiteWeather,
MSNWeather.CurrentWeather(
ComboBox1_1.SelectedItems.'Lat.' & "." & ComboBox1_1.SelectedItems.'Lon.',
"Imperial"
)
)& (Navigate('Current Weather',ScreenTransition.Fade))

@Lmcginnis this community has a WEALTH of information, if you search for it.  As @Mr-Dang-MSFT suggests, pick a term you think is related to what you want to do and enter it in the search box.  Focus, in particular, on posts marked as having a solution (green check mark) as these are most likely to give you an "answer".  Often, I can piece together what I need to know by looking at several of these posts.

 

Here's a couple of my past posts that might be useful:

On Patch:  https://powerusers.microsoft.com/t5/General-Discussion/Sharepoint-list-value-created-from-powerapp-o...

On writing to Excel:  https://powerusers.microsoft.com/t5/General-Discussion/Patch-Collection-And-Email/m-p/272835#M79721

 

And here's a question I asked and got answered on the relationship between Patch and SubmitForm:  https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Question-on-sequence-of-Patch-and-Submi...

 

Also, check out the YouTube videos from @Shanescows (search YouTube for Shane Young's channel).  They will give you step by step instruction on MANY topics.  Look over what topics he has available so you are aware of the resources available from him when you get stuck in the future.

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Watching the video now, havent finished it yet...

But I'd like to save completed files to a phone if there is no internet, so they can be accessed if needed.

Maybe an option if it is possible, when the app starts it checks for saved files, compares them to entries online, and uploads them if doesnt exist?

Perhaps with just a couple of checks, like date/time/place ... no need to check every entry.

 

thanks.

Helpful resources

Announcements

Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

  It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd. at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3rd, 2024 at 9:30 AM PDT and join us for an engaging and informative session!

Tuesday Tip: Unlocking Community Achievements and Earning Badges

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!     THIS WEEK'S TIP: Unlocking Achievements and Earning BadgesAcross the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. These badges each signify a different achievement--and all of those achievements are available to any Community member! If you're a seasoned pro or just getting started, you too can earn badges for the great work you do. Check out some details on Community badges below--and find out more in the detailed link at the end of the article!       A Diverse Range of Badges to Collect The badges you can earn in the Community cover a wide array of activities, including: Kudos Received: Acknowledges the number of times a user’s post has been appreciated with a “Kudo.”Kudos Given: Highlights the user’s generosity in recognizing others’ contributions.Topics Created: Tracks the number of discussions initiated by a user.Solutions Provided: Celebrates the instances where a user’s response is marked as the correct solution.Reply: Counts the number of times a user has engaged with community discussions.Blog Contributor: Honors those who contribute valuable content and are invited to write for the community blog.       A Community Evolving Together Badges are not only a great way to recognize outstanding contributions of our amazing Community members--they are also a way to continue fostering a collaborative and supportive environment. As you continue to share your knowledge and assist each other these badges serve as a visual representation of your valuable contributions.   Find out more about badges in these Community Support pages in each Community: All About Community Badges - Power Apps CommunityAll About Community Badges - Power Automate CommunityAll About Community Badges - Copilot Studio CommunityAll About Community Badges - Power Pages Community

Tuesday Tips: Powering Up Your Community Profile

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week's Tip: Power Up Your Profile!  🚀 It's where every Community member gets their start, and it's essential that you keep it updated! Your Community User Profile is how you're able to get messages, post solutions, ask questions--and as you rank up, it's where your badges will appear and how you'll be known when you start blogging in the Community Blog. Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile.     Password Puzzles? No Problem! Find out how to sync your Azure AD password with your community account, ensuring a seamless sign-in. No separate passwords to remember! Job Jumps & Email Swaps Changed jobs? Got a new email? Fear not! You'll find out how to link your shiny new email to your existing community account, keeping your contributions and connections intact. Username Uncertainties Unraveled Picking the perfect username is crucial--and sometimes the original choice you signed up with doesn't fit as well as you may have thought. There's a quick way to request an update here--but remember, your username is your community identity, so choose wisely. "Need Admin Approval" Warning Window? If you see this error message while using the community, don't worry. A simple process will help you get where you need to go. If you still need assistance, find out how to contact your Community Support team. Whatever you're looking for, when it comes to your profile, the Community Account Support Knowledge Base article is your treasure trove of tips as you navigate the nuances of your Community Profile. It’s the ultimate resource for keeping your digital identity in tip-top shape while engaging with the Power Platform Community. So, dive in and power up your profile today!  💪🚀   Community Account Support | Power Apps Community Account Support | Power AutomateCommunity Account Support | Copilot Studio  Community Account Support | Power Pages

Super User of the Month | Chris Piasecki

In our 2nd installment of this new ongoing feature in the Community, we're thrilled to announce that Chris Piasecki is our Super User of the Month for March 2024. If you've been in the Community for a while, we're sure you've seen a comment or marked one of Chris' helpful tips as a solution--he's been a Super User for SEVEN consecutive seasons!       Since authoring his first reply in April 2020 to his most recent achievement organizing the Canadian Power Platform Summit this month, Chris has helped countless Community members with his insights and expertise. In addition to being a Super User, Chris is also a User Group leader, Microsoft MVP, and a featured speaker at the Microsoft Power Platform Conference. His contributions to the new SUIT program, along with his joyous personality and willingness to jump in and help so many members has made Chris a fixture in the Power Platform Community.   When Chris isn't authoring solutions or organizing events, he's actively leading Piasecki Consulting, specializing in solution architecture, integration, DevOps, and more--helping clients discover how to strategize and implement Microsoft's technology platforms. We are grateful for Chris' insightful help in the Community and look forward to even more amazing milestones as he continues to assist so many with his great tips, solutions--always with a smile and a great sense of humor.You can find Chris in the Community and on LinkedIn. Thanks for being such a SUPER user, Chris! 💪🌠

Find Out What Makes Super Users So Super

We know many of you visit the Power Platform Communities to ask questions and receive answers. But do you know that many of our best answers and solutions come from Community members who are super active, helping anyone who needs a little help getting unstuck with Business Applications products? We call these dedicated Community members Super Users because they are the real heroes in the Community, willing to jump in whenever they can to help! Maybe you've encountered them yourself and they've solved some of your biggest questions. Have you ever wondered, "Why?"We interviewed several of our Super Users to understand what drives them to help in the Community--and discover the difference it has made in their lives as well! Take a look in our gallery today: What Motivates a Super User? - Power Platform Community (microsoft.com)

March User Group Update: New Groups and Upcoming Events!

  Welcome to this month’s celebration of our Community User Groups and exciting User Group events. We’re thrilled to introduce some brand-new user groups that have recently joined our vibrant community. Plus, we’ve got a lineup of engaging events you won’t want to miss. Let’s jump right in: New User Groups   Sacramento Power Platform GroupANZ Power Platform COE User GroupPower Platform MongoliaPower Platform User Group OmanPower Platform User Group Delta StateMid Michigan Power Platform Upcoming Events  DUG4MFG - Quarterly Meetup - Microsoft Demand PlanningDate: 19 Mar 2024 | 10:30 AM to 12:30 PM Central America Standard TimeDescription: Dive into the world of manufacturing with a focus on Demand Planning. Learn from industry experts and share your insights. Dynamics User Group HoustonDate: 07 Mar 2024 | 11:00 AM to 01:00 PM Central America Standard TimeDescription: Houston, get ready for an immersive session on Dynamics 365 and the Power Platform. Connect with fellow professionals and expand your knowledge. Reading Dynamics 365 & Power Platform User Group (Q1)Date: 05 Mar 2024 | 06:00 PM to 09:00 PM GMT Standard TimeDescription: Join our virtual meetup for insightful discussions, demos, and community updates. Let’s kick off Q1 with a bang! Leaders, Create Your Events!    Leaders of existing User Groups, don’t forget to create your events within the Community platform. By doing so, you’ll enable us to share them in future posts and newsletters. Let’s spread the word and make these gatherings even more impactful! Stay tuned for more updates, inspiring stories, and collaborative opportunities from and for our Community User Groups.   P.S. Have an event or success story to share? Reach out to us – we’d love to feature you!

Top Solution Authors
Top Kudoed Authors
Users online (4,871)