All board posts in Power Apps Community

Re: Prediction not writing into explanation/predicted/probability fields

ryandarbysensei — Wed, 21 Apr 2021 02:52:41 GMT

Thanks that did the trick!

Re: Weighted % of funding calculation

v-bofeng-msft — Wed, 21 Apr 2021 02:49:21 GMT

Hi :

Could you tell me if this can meet your needs?

If so,I've made a test for your reference:

I assume there is a table-TheDateBase

ClearCollect( TheDateBase, {Project:"Project 1",Found:"BU1",Static:20%}, {Project:"Project 1",Found:"BU2",Static:80%}, {Project:"Project 2",Found:"BU3",Static:100%} )

1\Add a gallery(Gallery6) and set it's Items property to:

Table({Split:"Project 1"},{Split:"Project 2"})

2\Add a TextInput(TextInput1) control in to Gallery 6

3\Add an Other Gallery(Gallery7) and set it's Items property to:

Distinct(TheDateBase,Found)

4\Add a label control into Gallery7 and set it's Text property to:

Sum( ForAll( Gallery6.AllItems As GalleryAllItem, LookUp( TheDateBase, Project = GalleryAllItem[@Split] && Found = ThisItem.Result ).Static * GalleryAllItem[@TextInput1].Text ), Value )

Best Regards,

Bof

Re: Power Apps Portal Mobile Phone Scaling

Fubar — Wed, 21 Apr 2021 02:43:11 GMT

Just looked at the home page. I avoid using the studio (at this stage) as I'm used to doing it from within the Portal Management App.

At the end of the day any edits you make (add an Image etc) you will need to make sure the appropriate settings are set.

The Portal is 'width' aware, in that there are a number of Media tags in the Bootstrap min file that are used by the portal to help define content widths etc at differnet screen sizes. These can be overridden in your own CSS file (but don't edit the ones provided as some times the files provided get replaced and you may find your changes are not working as they in the old version of the CSS file).

Re: Is there a simple way to copy entity data and webpage setting to other environments?

Audreyma — Wed, 21 Apr 2021 02:36:57 GMT

I chose to import data through CSV file.

Even if I selected "Load to a new table", data import failed as well, said that "cr8f8_id" is the reserved column name for table "cr8f8_". .

And I found that data type is not identified correctly, option set will be recognized as "text".

For the error itself, I guess it's necessary that column name should be unique in Dataverse, so I can't use the same name in 2 environments.

But it seems to be impossible to set new column name in the target env.

Re: Setting items in a gallery for icon or buton click

v-albai-msft — Wed, 21 Apr 2021 02:35:12 GMT

Hi ,

How are things going? Is my reply helpful to your issue?

I am willing to hear from you.

Best regards,

Allen

Re: Filter view from toggle button

v-albai-msft — Wed, 21 Apr 2021 02:22:35 GMT

Hi ,

How are things going? Is my reply helpful to your issue?

I am willing to hear from you.

Best regards,

Allen

Re: How avoid delegation in Lookup with use of Title or Record Items

v-albai-msft — Wed, 21 Apr 2021 02:17:19 GMT

Hi ,

How are things going? Is my reply helpful to your issue?

I am willing to hear from you.

Best regards,

Allen

Re: Check Multiple Dropdowns Selected Values and Define 'Yes' or 'No'

v-qiaqi-msft — Wed, 21 Apr 2021 02:12:31 GMT

Hi ,

Okay, I understand what you want to achieve.

You want the If statement to return true if there is any one of the condition is met.
You want the If statement to return false if there is any one of the condition is not met.

If you want any of the condition specified to be met then ApprovalCheck should have 'Yes' and all (even one)condition is not met then ApprovalCheck should have 'No', I could tell you that there is no way to achieve this using the logic statement.

The Or operator means that once one of the condition is met, then it returns true, only if all the conditions are not met at the same time, it returns false.

The And operator means that only all the conditions is met, it returns true, and if only one of the conditions is met, it returns false always.

More details, please check here for reference.

Hope it could help.

Regards,

Re: App cannot create record and throwing up customerid error

Drrickryp — Wed, 21 Apr 2021 02:02:14 GMT

Go back into the table and turn off the required property for the customerid. It is assigned automatically.

Re: Update Collection on Gallery selected

Ashok2 — Wed, 21 Apr 2021 02:01:30 GMT

Hi

I changed my question can you please check now and let me know if its clear ?

Re: Data repeat restriction

WarrenBelz — Wed, 21 Apr 2021 01:58:23 GMT

Hi ,

The code I supplied should do that - it is checking for a the existence of a record where you have the user's name in one field and the date selected by the user in another field. If this record exists, the message pops up and the date picker is cleared.

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.

Re: Setting variable based on Date column value

WarrenBelz — Wed, 21 Apr 2021 01:55:26 GMT

,
Let's go a step back (replace with your date field name) at screen OnVisible

Set( approvedDate, Value(SharePointIntegration.Selected.YourDateFieldName)=0 )

Re: Get distinct from 2 columns and sum the unique values

WarrenBelz — Wed, 21 Apr 2021 01:50:13 GMT

HI ,

Where did you put that code - as the Items of a Gallery, it will show the number of unique records with the combination of THDepartment and THBudgetID. and is valid code for this (I also just tested it here).

Re: Update Collection on Gallery selected

v-bofeng-msft — Wed, 21 Apr 2021 01:33:01 GMT

Hi :

Sorry, I still don't understand how you need to perform the "Edit Collection Records I Need to Realize".

Best Regards,

Bof

Re: Theres a problem with power apps studio right now

v-bofeng-msft — Wed, 21 Apr 2021 01:27:25 GMT

Hi :

You could log in to the admin center and then select "Help + Support'

Best Regards,

Bof

Approval process Flow - Link to item does not display any data

cpmhaitang — Wed, 21 Apr 2021 01:32:16 GMT

Hi,

I am creating an approval process for when an employee requests a certain change to be made in a business dictionary:

1. User submits change request --> new item gets created in Sharepoint list with 'Pending' Status

2. Manager receives pending approval message with link to item

3a. Manager approves --> item updates Status to 'Approved'

3b. Manager rejects --> item updates Status to 'Rejected'

The issues I'm facing are:

The form to be approved by the manager shows none of the information filled-in by the user.
After approving, the Status column does not get updated to Approved or Rejected.
The manager receives an email with approval confirmation, but then afterwards gets another request for approval email.

Empty be approved form from "Link to item":

Flow:

Kind regards,

Charlie

Re: Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 01:17:26 GMT

now is working Thank you for your help

ForAll(Gallery1.AllItems;Patch(Answer_Data;Defaults(Answer_Data); {Answer:ThisRecord.TextInput1.Text;Q_Id:ThisRecord.Label6.Text;Answer_Dates:DatePicker1.SelectedDate;User_Name:TextInput2.Text}))

Re: Gallery questions and answers save excel

KrishnaV — Wed, 21 Apr 2021 01:16:53 GMT

did this work for you???

Re: App pass auto-assignment process

ChrisPiasecki — Wed, 21 Apr 2021 01:16:32 GMT

Hi ,

The Per app license is assigned upom sharing an app with a user. To free up the license, you would need to unshare apps in that environment for a user.

You can reallocate your licenses among different environments to meet the usage needs. I don't believe you will see an error when sharing the app with the user when you're out of licenses, but the end user will experience one when trying to access the app.

Re: Display Site Pages and Site Lists in Dropdowns

KrishnaV — Wed, 21 Apr 2021 01:05:34 GMT

Hi ,

It is possible but how are planning to provide the data to those 2 dropdowns? from a specific list or you are expecting to populate dynamically?

Re: Gallery questions and answers save excel

KrishnaV — Wed, 21 Apr 2021 01:03:44 GMT

here is the complete code block, now this will add all the columns.

ForAll(Gallery1.AllItems,Patch(Answer_Data,Defaults(Answer_Data), {Answer:ThisRecord.TextInput1.Text;Q_Id:ThisRecord.Label6.Text;Answer_Dates:ThisRecord.DatePicker1.SelectedDate;User_Name:ThisRecord.TextInput2.Text}))

Re: Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 01:00:53 GMT

Hi Thank you but record just gallery answer i want to record like first colum

Re: Deleted a required column, still showing up during data import in mapping

ColdSpark — Wed, 21 Apr 2021 00:58:38 GMT

Yup, both done and have opened a case. Thanks!

Re: Gallery questions and answers save excel

KrishnaV — Wed, 21 Apr 2021 00:54:58 GMT

Do this,

ForAll(Gallery1.AllItems,Patch(Answer_Data,Defaults(Answer_Data),{Answer:ThisRecord.TextInput1.Text}))

Re: Deleted a required column, still showing up during data import in mapping

dpoggemann — Wed, 21 Apr 2021 00:53:31 GMT

Hi ,

I would verify the following:

1. Show "All fields" in your view of fields to really verify it is gone 🙂

2. Verify your environment to make sure you didn't delete from Dev and you are in Prod or something like that.

If both of these above are not the case then Open a case with Microsoft as something is not right.

Thanks much,

Drew

Best way to add 'Request Further Information' functionality to an external customer in model driven apps

jafitzpatrick19 — Wed, 21 Apr 2021 00:51:31 GMT

Requesting Further Information from customers, applicants and clients after they have submitted a some type of webform is a fairly common use case in many business processes.

Does anyone have any best practices or typical solutions for implementing this functionality?

e.g. use of workflows, statuses, BPF stages, email integration, activities.

Re: Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 00:45:04 GMT

in one drive

Re: Cannot filter data from input text box - Expected Record value

rocky_puff — Wed, 21 Apr 2021 00:44:45 GMT

Hi ,

I followed your instruction. And it gives me this error. And I dont really understand, supposed it works isnt? I also tried added a parentheses (to close the LookUp formula), still give me error. Need your guidance

Re: Gallery questions and answers save excel

KrishnaV — Wed, 21 Apr 2021 00:43:32 GMT

Hi ,

Where is your excel? is it in the app or in a sharepoint / ondrive? could you please elaborate more on how you are managing the data in the app?

Re: Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 00:43:05 GMT

i used this formul but record just one what is the wrong

Re: Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 00:40:48 GMT

i want to save answer excel

Re: Deleted a required column, still showing up during data import in mapping

ColdSpark — Wed, 21 Apr 2021 00:40:34 GMT

Unfortunately I have done all of these things. I have published all customizations and cleared cache in chrome. The field is still showing.

Re: Online/Offline sharepoint backup system creating duplicates.

Eelman — Wed, 21 Apr 2021 00:38:59 GMT

This video by Paul O'Flaherty is a really good explanation of working in offline mode. He uses the 3 things to identify records to be:

- added as new

- modified, and

- deleted

For adding new, he leverages the fact there is currently no ID value for a record.

For modifying, he adjusts the Modified Date to 1/1/3001.

For deleting, he adjusts the Modified Date to 1/1/3000.

Then using the above he Filters the local collection and updates his SP List accordingly. The video is 1hr 40min but well worth watching

Re: Gallery questions and answers save excel

KrishnaV — Wed, 21 Apr 2021 00:38:33 GMT

Hi ,

Where do you want to save the data? what is the data source you are using could you please elaborate more on this?

Re: Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 00:37:47 GMT

i used this formul but record just one what is the wrong

Patch(Answer_Data;Defaults(Answer_Data);{Answer:TextInput1.Text;Q_Id:Label6.Text;Answer_Dates:DatePicker1.SelectedDate;User_Name:TextInput2.Text})

Re: Data repeat restriction

Labraham36 — Wed, 21 Apr 2021 00:36:26 GMT

Thank you for your answer! But I think I explained it wrong. The problem is the following: My App only receives two data, a date and a number of hours corresponding to that date. What I need is that when the user enters a new date, if by mistake he enters a date that has already been registered, and wants to save, the app does not leave it since there cannot be more than one record per date. My data is saved in an excel in one drive, so what the function should do is check in the date field of my excel and if the date that was entered and is going to be saved had been entered before, then no it should allow you to save the record. I hope my problem is better understood and in advance thank you very much for your time !!!

Re: Checkbox Gallery with TextInput

KrishnaV — Wed, 21 Apr 2021 00:31:49 GMT

Hi ,

Add a textbox on the same column where you have added a checkbox to enable the textbox with the below formula on visible property.

CheckboxOther.Value

at the time of submit add the value provided in the textbox to SharePoint list.

Graphics Problems

Labraham36 — Wed, 21 Apr 2021 00:26:49 GMT

hello community! I have a query about graphics in power apps. I have an App that records two pieces of information: A date and a number of hours. I want to make some graphs with this data that measure the number of hours per month. What happens is that the graph lets me put the date on the x axis and the number of hours per day on the y axis. I would like you to add up the number of hours in the month and show me a bar graph with the months on the x-axis, and the total number of hours for the month on the bar. How could I do this? I leave an image of the graph that shows me the number of hours in the day. That I want to pass it to month. Thanks!

Re: Setting variable based on Date column value

KSMB — Wed, 21 Apr 2021 00:22:46 GMT

Hi , Thank you for the idea, I set this in 'On Edit' property of SharePoint Integration control.

When I edit a list item first time, condition is not triggered. But I cancel and edit the same list item again, everything works as expected.

Tried to set the variable in EditScreen- OnVisible() as well and same issue. Not able to figure out what is going on.. : (

Gallery questions and answers save excel

dursunzeeee — Wed, 21 Apr 2021 00:19:19 GMT

Hi i have to table questiondata and Answe_data

i need save the answer from the gallery1

Create PDF without premium connector and populate dynamic data

KrishnaV — Wed, 21 Apr 2021 00:15:03 GMT

In this video, I have explained how to create a Create PDF without Premium Connector in Power Automate. I have explained: ⚡ Create PDF with Dynamic Data
⚡ Create Key value pair with JSON format
⚡ Convert HTML file to PDF

⚡ Get the image content with the Get File content from One Drive

⚡ How to use dataUri function.

watch?v=KGLtKl97OGo

Re: Storage Capacity

dpoggemann — Wed, 21 Apr 2021 00:12:38 GMT

Hi ,

It looks like you might be in a trial tenant with the allocations but maybe not.

If you purchase a single "Power Apps Per User" license you will be granted 10GB of storage in your tenant. This is always a first recommendation for my customers to get that storage allotment in the dataverse. The list price for this is $40 per user / month. You will also get allocations for every user that is added to the environment for either Power Apps Per User or Power Apps Per App licenses but these allocations are different.

A great detailed guide is here.

General table from this guide is below

As you can see you get 250 MB of database capacity for each additional Power Apps Per User plan and 50 MB for each Power Apps Per App plan.

Hope this helps! Please accept if answers your question or Like if helped in any way.

Thanks,

Drew

Re: Storage Capacity

ChrisPiasecki — Wed, 21 Apr 2021 00:08:58 GMT

Hi ,

When you create an environment, it reserves 1GB of storage capacity regardless if it is using less.

More informatiom in environments and storage capacity is provided here.

Note: there is typically a delay in the storage capacity reports so may need to wait a bit until any storage you free up is reflected.

Re: Multi select combo box clear other values if "none of the above" selected

WarrenBelz — Tue, 20 Apr 2021 23:53:23 GMT

Firstly, you must have the Variable varNoneAbove already defined as another data type - I tested the syntax here and it worked fine. If you simply want to reset the control, do this OnChange

If( "None of the above" in Self.SelectedItems.Value, Reset(Self) )

Checkbox Gallery with TextInput

cperry07 — Tue, 20 Apr 2021 23:52:09 GMT

Hey Guys,

I have a form where I have added a Gallery for checkbox inputs. I have one of the checkbox choices as "Other". I would like to provide the user the ability to fill a Text Input if the "Other" option is selected. Is there a way I can do this since the checkboxes are inside of a gallery? The SharePoint column is a choice column, but I have allowed the ability to add manual data.

Thanks

Chris

Storage Capacity

slalithp — Tue, 20 Apr 2021 23:50:24 GMT

What and from where do I get this storage capacity from? Is 1 GB the default environment dataverse capacity? I have just created few environments with few canvas applications. Why is the data getting filled up when I do not use any files in my application? I use Excel and SQL server as my datasources, what exactly is happening? I have deleted the environments and applications except default environment but I still see the Storage is full and cannot create a new environment. how can I create a new environment again?

Re: Get distinct from 2 columns and sum the unique values

SaeedKamel — Tue, 20 Apr 2021 23:48:40 GMT

Thank you for the reply

but i get this error message

" Expected Text Value"

Filter Gallery by User button

cperry07 — Tue, 20 Apr 2021 23:47:40 GMT

Hey Guys,

I have a gallery where I allow the ability to filter the gallery by the buttons "All" "In Progress" "Pending" & "Complete"

I have created a collection of "ToggleCol"

I would also like to add a button where the user can filter Tasks assigned to them named "My Tasks"

I have a form that the users have the ability to add users, which in SharePoint is a Users/Groups field. They can add multiple users to an assigned task. Is there a way that I can Filter the gallery for any tasks associated with a particular user by clicking a button as well? I have tried a few different methods, but none successful. The SharePoint Column Name is 'Responsible Person'

Thanks

Chris

Re: Form - Aligning Field Heights

RandyHayes — Tue, 20 Apr 2021 23:45:58 GMT

So interesting that you were watching the video at the same time! Yes, not much on the height issue as there really isn't much.

I would say that you just need to assess your situation and see if the stock form (perhaps broken up in to multiple forms) is the best approach, or putting together your own interface for the form is better.

Sometimes you get into a scenario where you also need to "tab" your interface by having the form broken into tabs. This is a possibility as well. I have another video on that very topic in the works but it is not published yet.

Please do take a look through the videos and see if you have any questions on it or still on the best approach....I'd be happy to provide answers as you might need.

Re: Setting variable based on Date column value

WarrenBelz — Tue, 20 Apr 2021 23:44:35 GMT

Hi ,

If you want the Variable to be true if the date picker is blank, try this

Set( approvedDate, Value(DataCardValue11_2.SelectedDate)=0 )

Re: Deleted a required column, still showing up during data import in mapping

dpoggemann — Tue, 20 Apr 2021 23:39:56 GMT

Hi ,

I walked through this process with a custom table and did the following steps and the column I deleted no longer appeared, can you try and verify?

1. I removed the column from all forms / views / business rules / controls etc.

2. I deleted the field from the Table in the dataverse

3. I navigated to Solutions in the make.powerapps.com and I chose to "Publish All Customizations"

4. I went to the table again and chose the Data --> Get Data --> Get Data From Excel

5. The field no longer existed in the dataverse side to map to. Of course I still had in my Excel file but no field to map to in the dataverse.

If the steps above do not work, can you try clearing cache in your browser? I am using Chrome...

Thanks,

Drew

Re: Text Input &

StephenGW — Tue, 20 Apr 2021 23:37:10 GMT

It's always more simple than I am making it 🙂 I was trying to add it to the text input that already does the Filter but I guess I should have just been adding it into the Mail function. Thank you as always for the quick and concise reply!

Re: Form - Aligning Field Heights

Beach9271 — Tue, 20 Apr 2021 23:36:13 GMT

Hi Randy!

Perfect timing! I was actually just watching one of your form videos seeing if I could find an answer. Couldn't find the height answer but your video is awesome and has a ton of information so thank you for sharing with us 😁

I should have added that the data I presented above is actually at the bottom of a single form with 8 fields above the Toggles. Would you concur that this may need to broken into 3 individual forms to work?

the first form containing the 8 data fields above the Toggles,

the second form containing the Toggles,

and the third form containing the attachments?

Just trying to get an overall idea of how best to approach this. I will definitely be watching your videos as well to figure out how best to achieve the saving of space.

Thank you!!!!!!!!

Online/Offline sharepoint backup system creating duplicates.

FarrellDrafting — Tue, 20 Apr 2021 23:30:15 GMT

So I've made an app for a field crew to record quality control conditions, it saves data locally when offline, and uploads when online. it also stores each record locally as a backup if an upload to sharepoint fails or if the record is deleted from the back end.

It works fine if there are no edits made to the record. but if the record is changed, even if the strings its checking are identical, it will push a new duplicate record. See example code below, it runs on a trigger to check the backup data against the sharepoint list.

Collect( ElementData, Filter( ElementDataBackup, Not( And( Text(ElemQCNum) in ElementData.ElemQCNum, Text(DrillCount) in ElementData.DrillCount, Text(Title) in ElementData.ProjectFullName ) ) ) );

does anyone else have a cleaner "upload if record doesn't exist online"? "ElementData" is the online list, "ElementDataBackup" is the local collection. all column names are double checked and correct.

Re: Division in gallery label is behaving strange

timl — Tue, 20 Apr 2021 23:30:09 GMT

There seems to be a pattern whereby any Plan value greater than 1,000 doesn't calculate correctly.

When I look at your screenshot, it looks as though there may be a space between the 1,000 digit and the remaining numbers.

Text( (Value(txtUtfall.Text) / Value(Substitute(Label5.Text;" ";"")))*100; "[$-sv-SE]#" )

Re: Send email when new record not created

dpoggemann — Tue, 20 Apr 2021 23:19:33 GMT

hi ,

I would follow the same approach as here, which is great!. Other things I would do to really help build this for stability and scalability going forward is you may want to add fields to the User table in Dataverse (or a related table 1:N from User table) for configurations like this. It would allow you to build a flexible configuration where users can control the types of notifications they receive and when they receive. Example, you could have a field that is a "Yes / No" to receive notifications on the file notes and then another field on how often. This could be extended to many other types of notifications in the system. It would provide the power in the user's hand to control their notification strategy and the automation around this that can be different per user.

Hope this provides some value. Please like if it does because provided the real answer 😃

Thanks,

Drew

Re: Deleted a required column, still showing up during data import in mapping

ColdSpark — Tue, 20 Apr 2021 23:16:59 GMT

I am referring to the data mapping interface that comes up after you select Data > Get Data > Get Data from Excel, and then upload a csv. It is always still showing the deleted column that i have confirmed is gone when you go look at columns.

Re: Default Time Picker - Working for 'Hour' but not for 'Minute'

RandyHayes — Tue, 20 Apr 2021 23:15:59 GMT

Glad to help! Sorry about the extra ')' in the formula...now you have an extra - use it someplace where you might need it. 😂

Re: How to Modify a Data source into custom column gallery

RandyHayes — Tue, 20 Apr 2021 23:11:24 GMT

Set the Items property of your Gallery to:

AddColumns(GroupBy(yourDataSource, "User", "_recs"), "_maximum", CountRows(_recs))

Set a label in the Gallery to ThisItem.User and another to ThisItem._maximum

I hope this is helpful for you.

Re: Form - Aligning Field Heights

RandyHayes — Tue, 20 Apr 2021 23:09:13 GMT

Unfortunately, that level of arrangement is not available as the forms work from a grid or rows that are all equal height.

I can provide two options for you.

1) Split the form - there are some factors to consider with this when "connecting" them back together. I have some details on splitting forms in a Video on the topic. Normally everyone will say to Patch the forms when you submit, but this loses all the functionality of the form and wastes it. But since it is just the attachments that you want to move to the side, then you can easily Patch just the attachments on the OnSuccess of the first form submit.

Ex.

2) Build your own form. You can still use all of the features of the EditForm you have, just provide it your own interface instead of the one out of the box. I have a video on this topic as well. In particular Part 3 of the video will provide details on that.

I hope this is helpful for you.

Re: Filter records in Calendar Control V2 in Model-Driven

dpoggemann — Tue, 20 Apr 2021 22:48:48 GMT

Hi ,

I just setup the exact scenario in my instance and I receive an error every time I go into the filter when having the calendar control v2 active. The error I receive is the following (even without adding any additional criteria):

This is a bug and you should open a case with Microsoft but I was able to work around this issue.

If I put in "read only grid" and enter all of the filter criteria then when I put into calendar mode with the V2 control it worked successfully to show in the calendar grid with my records that were filtered.

Hope this helps! Please accept if answers your question or Like if helped in some way.

Thanks,

Drew

Re: 256 rows limit getting rows from excel

sajarac — Tue, 20 Apr 2021 22:42:48 GMT

Hello MS Guys.

Quick question. I am trying to copy my giant excel file "close to 1M rows by 12 columns" I have a combination of Text and Date columns".

Could you please let me know How many hours this operation will take? and also is possible to copy all those rows? or only the maximum threshold of 100000?

Form - Aligning Field Heights

Beach9271 — Tue, 20 Apr 2021 22:42:34 GMT

Hello,

I have an app with a form. The users are tired of scrolling and want to shorten the form itself. Currently the fields are aligned as:

Toggle1 - height 50

Toggle2 - height 50

Toggle3 - height 50

Toggle4 - height 50

Toggle5 - height 50

Attachments - height 250

They want to align the columns to reduce scrolling and use less space as follows:

Toggle1 - height 50 Attachments - height 250

Toggle2 - height 50

Toggle3 - height 50

Toggle4 - height 50

Toggle5 - height 50

I have tried setting the form to 1 column and 2 columns. I've also tried the X,Y coordinates but cannot seem to align the fields as the Attachments-height 250 ends up changing Toggle1 from a height of 50 to a height of 250 to match the Attachments height thus wasting valuable space:

Toggle1 - height 50 250 Attachments - height 250

Toggle2 - height 50

Toggle3 - height 50

Toggle4 - height 50

Toggle5 - height 50

Any thought on if this is possible or how best to fulfill this request? Thank you in advance.

Re: Is there a simple way to copy entity data and webpage setting to other environments?

ragavanrajan — Tue, 20 Apr 2021 22:38:00 GMT

hI ,

The answer is no need to create the table first in your target environment. It depends on your need. Adding a screenshot for your reference. You can load to a new table and map the relevant fields.

Or if the situation changes if you want to continue the process from source to target environment then you need to pick the "Load to Existing table" and make sure you have proper data types.

Hi , Thank you for the info. The reason why I mentioned this method is the user prefers a different way rather than a configuration tool or XRM tool box.

Hope it helps.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

How to Modify a Data source into custom column gallery

PowerO365Guy — Tue, 20 Apr 2021 22:27:21 GMT

Hi Community,

I have a requirement. I am trying to figure out using groupby , addcolumns but unable to achieve what i need.

I have a table like below with user and candy. I want to create a new gallery where the users information is stored along with the no of candy allowed. (So if for example Antony occurs more than 3 times , then the Maximum column should be 3, if its less than 3 , then no issue)

Datasource/Table

Expected table into a Gallery

Re: Multi select combo box clear other values if "none of the above" selected

RoarkeP — Tue, 20 Apr 2021 22:24:10 GMT

Thank you for responding!

Multi-select combo box

Choices are pulled from a SharePoint list ("A", "B", "C", "D", "None of the above")
When users selects "None of the above" I want to remove any other values also selected ("A" - "D")

When I put your code in the OnChange property of the DataCardValue, the "=" causes an error:

Do you need to know more to suggest other ideas?

Simple One to many relationship adding a record to the related table

Rbie — Tue, 20 Apr 2021 22:23:58 GMT

Hi all,

I have a very simple dataverse setup, 2 tables, Events (fields: Name, Date, Deadline) and participants (fields: Email, Name)

with a one to many relationship.

I have a screen where I show the event in a form and a button to subscribe.

I just have no idea what to put in the button on select event to add the user to the participants table.

I have another screen with the event information and a dropdown where I want to list all the related people in the participants table, I'm also baffled how to fill this dropdown with the participants.

I tried to patch it like

Patch(Events,Gallery1.Selected,{Participants.Email

but the related participant is not available yet

Seems something simple but I can't seem to find anything on the web about this

Thanks in advance

Rbie

Setting variable based on Date column value

KSMB — Tue, 20 Apr 2021 22:21:38 GMT

Hi All,

I am customizing SharePoint forms and in the Edit form, if the Approved Date has a value, then all the date cards will be have the Display Mode set to 'View'.

I set the global variable:
If(IsBlank(Text(DataCardValue11_2.SelectedDate)),Set(approvedDate,true),Set(approvedDate,false)

Displaymode of each datacard: If(approvedDate, DisplayMode.View, DisplayMode. Edit)

This doesnt work, can you please suggest or recommend how to set this variable coreectly?

Thanks in advance!

regards,

Re: COMPLICATED IF FUNCTION.

WillPage — Tue, 20 Apr 2021 22:18:23 GMT

Slightly cleaner version:

If( Value <= 3, Code1 + RoundDown( Code1 / 11, 0 ) - 60 + If( Code1 in [76,86,87], 1, 0 ), Value(Character) )

Re: Return to the workplace

RyanFair — Tue, 20 Apr 2021 22:18:03 GMT

Facilities app: I have a disconnect between what phase the BPF shows as active and what is actually active. Plus, for occupancy capacity, the app isn't allowing any bookings.

Ideas?

Re: Deleted a required column, still showing up during data import in mapping

dpoggemann — Tue, 20 Apr 2021 22:12:41 GMT

Hi ,

If you delete the column and publish the solution the column will be removed from the data import template if you download a new template. Where are you seeing the column when you say the "data mapping interface"? Is this the data import wizard and are you utilizing a map that you had saved in the past? If so, I would suggest creating a new map.

Hope this helps, let me know if I am missing what you are asking... If this did solve, please mark accepted. If it helps somewhat then please like if possible.

Thanks!

Drew

Re: Division in gallery label is behaving strange

WarrenBelz — Tue, 20 Apr 2021 22:11:47 GMT

Hi ,

I think you have one bracket in the wrong place

Text( ( Value(txtUtfall.Text) / Value(Label5.Text) *100 );"[$-sv-SE]#" )

Re: Duplicate records adding from collection to database

Drrickryp — Tue, 20 Apr 2021 22:09:37 GMT

I would still try use the form and add a patch for any other values in the OnSuccess property using the form's LastSubmit property to identify the record being patched. As points out in his Forms Plus video here https://www.youtube.com/watch?v=w724AECyMxo there are many advantages to using the built in features of the form.

Division in gallery label is behaving strange

Petter120 — Tue, 20 Apr 2021 22:09:04 GMT

Hi i have this gallery and in the column Målu. im trying to calcualte the complience (Utfall / Plan) and the weird thing is

that not all columns are getting calculated.

I use this formula in my text property

Text((Value(txtUtfall.Text) / Value(Label5.Text))*100;"[$-sv-SE]#")

If i change the division to addition numbers will apear in all cells.

Thanks Petter

Re: Text Input &

WarrenBelz — Tue, 20 Apr 2021 22:07:57 GMT

Hi ,

You did not mention the field name that actually has the email in it, but you would need something like this

Concat( Filter( Emails, Location = dLocation.Selected.Locations && Department = ddDepartment.Selected.Result ).EmailFieldName & ";" ) & ";" & tiAddNote.Text

Re: Trigger a pop up based on Excel Column

Sahara22 — Tue, 20 Apr 2021 22:06:09 GMT

Ok Thank you

Re: Dates in power apps

WarrenBelz — Tue, 20 Apr 2021 22:01:31 GMT

Hi ,

Turn on Formula Level Error Management in your Advanced Settings and see if that helps.

Re: Duplicate records adding from collection to database

vakula — Tue, 20 Apr 2021 22:01:25 GMT

Not all the items are in a form, so I have to go with using the patch.

Re: Set Calender (Screen 1) as default when open app

WarrenBelz — Tue, 20 Apr 2021 22:00:05 GMT

I am not sure how that relates to your question about screen navigation, but glad you got it working.

Re: Duplicate records adding from collection to database

Drrickryp — Tue, 20 Apr 2021 21:58:46 GMT

Ack! you never mentioned a form. The solution would be completely different if you are submitting a form and recreating a collection. In that case I would have just used SubmitForm() instead of patching the datasource and then recreated the collection with a ClearCollect(). Your validation could be built into the form's OnSuccess and OnFailure properties.

Dates in power apps

hiti — Tue, 20 Apr 2021 21:55:24 GMT

Hi,

Few records in sharepoint showing the date as 1/2/2023, when I am trying to delete these dates from power apps or sharepoint they are not getting deleted. Can anyone help me with this pls? These dates are appearing only in few items. However, not able to delete them from the power apps form, and also I tried to delete the version history, nothing is getting updated.

Regards

Re: Duplicate records adding from collection to database

vakula — Tue, 20 Apr 2021 21:54:58 GMT

But that's causing me another problem. After updating the collection from database, the form is clearing out all the values... 🙂

Re: Set Calender (Screen 1) as default when open app

ValerieAn — Tue, 20 Apr 2021 22:14:30 GMT

I was able to correct it to:

Set(_userDomain, Right(User().Email, Len(User().Email) - Find("@", User().Email))); Set(_dateSelected, Today()); Set(_firstDayOfMonth, DateAdd(Today(), 1 - Day(Today()), Days)); Set(_firstDayInView, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days)); Set(_lastDayOfMonth, DateAdd(DateAdd(_firstDayOfMonth, 1, Months), -1, Days))); Set(_calendarVisible, false); Set( _myCalendar, LookUp( Office365Oulook.CalendarGetTables().value, DisplayName = "Calendar")); Set(_minDate, DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days)); Set(_maxDate, DateAdd(DateAdd(_firstDayOfMonth, -(Weekday(_firstDayOfMonth) - 2 + 1), Days), 40, Days)); ClearCollect(MyCalendarEvents, Office365Outlook.GetEventsCalendarViewV2(_myCalendar.Name, Text(_minDate, UTC), Text(_maxDate, UTC)).value); Set(_calendarVisible, true)

Re: Trigger a pop up based on Excel Column

WarrenBelz — Tue, 20 Apr 2021 21:53:07 GMT

I was responding to your example which had specific values in an Excel sheet.

The "Name" would have to be in the list/table being looked up - I am simply checking that if the person signed in has their name in one column of a record and the value "Sign out" in the other, then set the pop-up to true.

Re: Is there any limitations in portal security and authentication?

ragavanrajan — Tue, 20 Apr 2021 21:49:11 GMT

Hi ,

Again, as mentioned this is really tricky to answer. Adding few more points

1. Two-factor authentication is available but it is not supported by portals yet. You can do some out-of-the-box features.

2. Multi-Factor authentication is only available if you configure Active Directory Federated Services (AD FS) with Azure MFA.

3. Passwordless is not yet available. But I believe in the future this will be available.

4. If you have plans to build a companion app to support powerapps portal, probably authentication and cross-site forgery should be taken into consideration. Ref: about companion app: https://www.engineeredcode.com/blog/dynamics-365-portal-custom-server-side-code-with-a-companion-app

Hope it helps.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

I'm new to the Flow/Power Apps platform and wondering if there is a chance for 1:1 tutoring?

jjudnich — Tue, 20 Apr 2021 21:48:37 GMT

Hello - I've been digging into the options and, as a novice, I'm at a dead end. We'd like to leverage the desktop flows to automate our SAP-ERP (Project Systems specifically) workload. I've tried to follow the

Re: Send email when new record not created

ChrisPiasecki — Tue, 20 Apr 2021 21:48:37 GMT

Hi ,

What you can do is create a scheduled Power Automate flow (e.g. Daily) to retrieve all of your records where any of its child records was not created in the last 2 months.

In the example below, I am retrieving all Accounts where there has been no notes created in the past 2 months. It also takes into consideration where there are no notes at all, so it will also return those records with no notes too.

Steps followed:

Create a trigger (I used a button for example, but you would use a recurring schedule trigger)
Initialize a variable that indicates the cutoff date. You can use the expression addToTime to subtract 2 months from the current time (e.g. 4/20/2021 - 2 months = 2/20/2021).
Add a Dataverse List Rows action to retrieve Accounts. In the Filter Rows, you need to specify an OData filter to get related records using the any or all operator.
- You need to specify the one-to-many relationship name between your 2 tables (you can find this in maker.powerapps.com > Data > Tables > "table name" > Relationships > "Relationship name"), then using the all operator indicating that all Notes must be created on the date that is less than or equal (le) than the date variable that was initialized (2 months ago).
- If you also want to include records where there is no child Notes at all, you can specify "not <relationship name>/any()" (in my example "not Account_Annotation/any()")
Add an Apply To Each and do whatever with each record returned from the List Records action (e.g. send an email).

Re: Hide Popup message on opening the form

WarrenBelz — Tue, 20 Apr 2021 21:48:33 GMT

Hi ,
One of the dangers of modifying SharePoint Integrated Forms - they are still "buggy" in a lot of ways. Try also putting that on the OnCancel, but other than that there are no other settings to change.

One last thing, if you make it a Global Variable (you will have to get rid of the other one)

Set(varPopup,true)

you could try at App OnStart

Set(varPopup,false)

Re: Duplicate records adding from collection to database

Drrickryp — Tue, 20 Apr 2021 21:49:17 GMT

Great! I may have screwed up but at least I helped get us on the right track. I am told that even a blind squirrel can sometimes find a nut!

Re: Duplicate records adding from collection to database

vakula — Tue, 20 Apr 2021 21:45:25 GMT

But with your approach, I changed my code. It seems to be working.

Here is what I did. First checked for duplicates using lookup, Then If no duplicates, then inserted data directly into database and then update my collection with database data.

Earlier, I was updating the collection first and then inserting the data into database, that was inserting duplicates.

Re: COMPLICATED IF FUNCTION.

WillPage — Tue, 20 Apr 2021 21:48:45 GMT

Ok I had a look at this. Trying to clever and actually figure out a formula to get the right number is hard. I'm no mathematician, so I hacked it like this:

Find this portion of the code:

If( Value <= 3, Code1 + RoundDown( Code1 / 11, 0 ) - 60, Value(Character) )

and update it like this:

If( Value <= 3, If(Code1 = 76 || Code1 = 86 || Code1 = 87, (Code1 + RoundDown( Code1 / 11, 0 ) - 60) + 1,Code1 + RoundDown( Code1 / 11, 0 ) - 60), Value(Character) )

It actually appears twice in the code I pasted above, but as I'm sure you guessed you can have a label with the first bit of the code (the non-rounded sum before the subtract) then use its Text property to continue with the calculation in other labels so you don't repeat the formula.

Re: PowerApps Nested if help

WarrenBelz — Tue, 20 Apr 2021 21:42:58 GMT

Hi ,

I am not sure what you are asking on the first question - you probably need to watch some videos such as these from or Shane Young . You might also have a read of the first couple of article from my site Practical Power Apps

For the second one - I realise this now - you have a Choice field (not a Text field).

Re: Azure AD and AAD security group teams

psathe — Tue, 20 Apr 2021 21:50:22 GMT

Re: Trigger a pop up based on Excel Column

Sahara22 — Tue, 20 Apr 2021 21:34:15 GMT

Thank you for your help again.

The "Name" isn't based on power apps, it's just different names inputed manually . Can I still use the same formula?

Re: Compare Gallery Items to Collection

WarrenBelz — Tue, 20 Apr 2021 21:32:04 GMT

Hi ,

That formula is valid (I just tested it here) if

ThisItem.ID is valid (you have the ID contained in the Gallery Items)
PDCollection also had the field ID in it
The label is in the gallery

Are any of these not true?

Re: Set Calender (Screen 1) as default when open app

ValerieAn — Tue, 20 Apr 2021 21:30:22 GMT

Thank you for your suggestion. That solution was not successful for me.

I tried this this formula in the OnStart field but it did not work as well due to some errors. Not sure what is incorrect.

Set( _userDomain, Right( User().Email, Len( User().Email ) - Find( "@", User().Email ) ) );
Set( _dateSelected, Today() );
Set( _firstDayOfMonth, DateAdd( Today(), 1 - Day( Today() ), Days ) );
Set( _firstDayInView,
DateAdd( _firstDayOfMonth, -( Weekday( _firstDayOfMonth) - 2 + 1 ), Days )
);
Set( _lastDayOfMonth, DateAdd( DateAdd( _firstDayOfMonth, 1, Months ), -1, Days ) );
Set( _calendarVisible, false );
Set( _myCalendar,
LookUp( Office365.CalendarGetTables().value, DisplayName = "Calendar" )
);
Set( _minDate,
DateAdd( _firstDayOfMonth, -( Weekday(_firstDayOfMonth) - 2 + 1 ), Days )
);
Set( _maxDate,
DateAdd(
DateAdd( _firstDayOfMonth, -( Weekday(_firstDayOfMonth) - 2 + 1 ), Days ),
40,
Days
)
);
ClearCollect( MyCalendarEvents,
Office365.GetEventsCalendarViewV2(_myCalendar.Name,
Text(_minDate, UTC ),
Text(_maxDate, UTC )
).value
);
Set( _calendarVisible, true )

Re: Duplicate records adding from collection to database

vakula — Tue, 20 Apr 2021 21:30:20 GMT

Should I patch it at the last of the code? from database to Collection?

Re: Delete all records in an CDS entity

jrussi1301 — Tue, 20 Apr 2021 21:29:45 GMT

You can edit the table direct on Excel. Delete all rows there and publish it to Dataverse.

Re: Duplicate records adding from collection to database

Drrickryp — Tue, 20 Apr 2021 21:31:53 GMT

I missed that. I think I may have screwed up in copying your formula. I'll start over and check it. In principle, I would separate out the patch to the collection and the patch to the datasource and also separate out the error check.

Re: Blop not found on an attahcment

WarrenBelz — Tue, 20 Apr 2021 21:26:47 GMT

Good - you got it working. I do not use that process much and that is an easier way providing you can send the ID of both lit items in the Flow.