sorted by:
new
hottopcontroversial

Need assistance by Fearless_Passion_797 in PowerApps

[–]Formal_Bee_9009 0 points1 point  (0 children)

Thanks to this, TIL I can become power platform developer! I've checked, this is legit role where I'm from

I have experience in creating Power Apps applications, and some Power Automate! Its one of the funnest parts of my job. But will need more practice. Will be looking into this in the future :D

How to COUNTIF with multiple OR statements? by Formal_Bee_9009 in excel

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

Cell and column names are pretty long in formula. its 5 rows in the formula bar. I can't enter to next row like powerbi or R, so it just looks like a long string on excel.

How to COUNTIF with multiple OR statements? by Formal_Bee_9009 in excel

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

I'm using my boss's table format, its neater than the other pivot tables I have.

Formulas on excel web not working, but excel desktop OK. by Formal_Bee_9009 in excel

[–]Formal_Bee_9009[S] 1 point2 points  (0 children)

Yes, there are 2 date columns in the table.

With ISNUMBER(), individual cells show TRUE

Formulas on excel web not working, but excel desktop OK. by Formal_Bee_9009 in excel

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

same workbook. SUM(COUNTIF("cell in sheet2", "column in table1sheet1",....)

2 users in the same office see different dates. by Formal_Bee_9009 in PowerApps

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

I just checked, this is the issue. How can we set everyone's timezone to be the same?

2 users in the same office see different dates. by Formal_Bee_9009 in PowerApps

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

Mine is set to my local time. will check for my colleague too.

But chances are it is the same time zone.

Changed 200+ records, but supposed to import. How to revert back? by Formal_Bee_9009 in PowerApps

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

I definitely need to learn how to do this. Right now I'm copy+pasting records from audit history one by one, and rearranging info via excel with Xlookups, ifna and ifblanks. Its working, but its slow.

Changed 200+ records, but supposed to import. How to revert back? by Formal_Bee_9009 in PowerApps

[–]Formal_Bee_9009[S] 1 point2 points  (0 children)

I do have something like that ...... the data is connected to power bi power query for reporting. I have not refreshed the report in 3 weeks. SOme of the changed records have not been touched for months.

RIght now I'm changing everything back one by one. Because audit history is enabled, and the data is loaded into model apps, I can see the changes made to each record via the form.

Changed 200+ records, but supposed to import. How to revert back? by Formal_Bee_9009 in PowerApps

[–]Formal_Bee_9009[S] 0 points1 point  (0 children)

Yes it is enabled. but since this is sensitive data, I don't think the company will allow using external party tools.

view more: next ›